Results 1 to 3 of 3

Thread: If/then conditional formulas and schedules

  1.    #1
    Junior Member
    Join Date
    September 10, 2014
    Posts
    28
    Current Local Time
    02:55 AM

    Not allowed! Not allowed!

    If/then conditional formulas and schedules

    hey all,

    so i have not messed with conditional formulas much at all. i am trying to figure out how i would go about getting this to happen....


    attached is a schedule that i am working with. in the column D "total hot" for all the zeros, i want to find out if there is an easy way to be able to state "if this is zero then replace with ---"

    i am just not sure how i would write that.... if(HWSFU <OR = TO 0, REPLACE WITH "---"? i am sure that i am way way off. but anything would help. i just cant seem to find this information anywhere.

    thank you
    Attached Thumbnails Attached Thumbnails 2020-01-06 11_47_15-Window.png  

  2.    #2
    Member
    Join Date
    September 19, 2017
    Location
    Seattle, WA
    Posts
    78
    Current Local Time
    01:55 AM

    Not allowed! Not allowed!
    You can't. A number field only displays a number and cannot be formatted as a text string. I really (really, really​) wish there were a way, but there isn't a way to do it currently. Dynamo could do those calculations and output the number as a string to a text-based shared parameter, but it will not update automatically.

    If it were me, I'd include the HWSFU even where not needed and just force them to zero. It ain't pretty, but at least the table would look completely populated.

  3.    #3
    Junior Member
    Join Date
    September 10, 2014
    Posts
    28
    Current Local Time
    02:55 AM

    Not allowed! Not allowed!
    awesome, thank you for the response.

Similar Threads

  1. Conditional Statements in schedules
    By katewood1989 in forum Architecture and General Revit Questions
    Replies: 2
    Last Post: November 21st, 2017, 09:57 PM
  2. Visibility conditional statements formulas - HELP
    By allan120791 in forum Architecture and General Revit Questions
    Replies: 4
    Last Post: March 28th, 2017, 11:14 PM
  3. Conditional Schedule Formulas
    By cupraymyun in forum Tutorials, Tips & Tricks
    Replies: 3
    Last Post: December 7th, 2016, 07:41 PM
  4. Schedules - more than one conditional format?
    By DDenton in forum Architecture and General Revit Questions
    Replies: 8
    Last Post: November 28th, 2016, 09:00 PM
  5. Conditional Formatting Door Schedules
    By d.stairmand in forum Architecture and General Revit Questions
    Replies: 2
    Last Post: May 13th, 2015, 02:38 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •