-
Symbols and Dropdown list
Is there anyway to associate dropdown list with symbols for display in card view?
-
How to Trigger Formatting from Comparison / Nested IF?
Hello! I have project sheet, with dependencies enabled. This requires manually updating the % Complete value. IĀ would like to add conditional formatting to remind myself to update the % Complete. IF [Completed]1 is not blank and IF [% Complete]1 does not equal 100% Then Format [% Complete]1 Cell Fill Yellow (screenshotā¦
-
Running formulas
It appears as though you have to open a sheet for a formula to run. Is this correct? I have reports that show out of date data due to the sheet not being opened therefore causing the formula to activate. Any suggestions? Thanks in advance. Richard
-
Automate RYGB based on Follow-up Date by Week
Community: I have tried but cannot figure out how to make this formula work. Probably something very simple, and I am overthinking. Any guidance would be much appreciated. Thank you, Sandy Scenario: Regardless of the day of the week I open my sheet: If [Follow-up date]1 is between M - F of the current week, RYGB symbol =ā¦
-
Sumif /Sumifs
Having trouble getting the sumif function to work. I have tried 2 versions, below =SUMIFS([Days Open]:[Days Open], Location:Location, [Repair Description]17) =SUMIF(Location:Location, [Repair Description]15, [Days Open]:[Days Open]) The [Days Open] is a number calculated by subtracting 2 dates (the cells with functions)ā¦
-
importing .mpp file
Hi I am not able to import the MPP file correctly in to smartsheet, please help. Any tips to import it correctly. The lines are off. Thanks
-
Compressed (zipped) Folder is invalid
Hi, Since last week if I want to open the zip folder from the download backup link it gives me the following error. Please assist. Y
-
Need help with Parent Status
I would like my parent status to be RED when ALL children balls are red, yellow when at least one is yellow, otherwise green. I found this formula below in a thread, but I can't seem to get Parent to RED when ALL are red. Can someone tell me what is missing? Thanks! =IF(COUNTIF(CHILDREN(), "Red") > 0, "Yellow",ā¦
-
Send Row Default Fields
Greetings, Will there ever be an option to save the "Send" (by row) "Include" options to be reused. I found a work-around to create a report with only the pertinent fields, but this is unwieldy. Example: When I have a support ticket to answer, I do not want all of the fields to display in the email and going through andā¦
-
Automate RYG Balls based on % complete and start and end dates
I would like to have the RYG balls automatically adjust based on the percent complete and start and end date. For instance, if my task is set to start on 10/2/17 and end 10/13/17, if my % complete is less than 50% by midway between the two dates, to turn yellow. If my % complete is less than or equal to 90% by the end dateā¦