Sign in to join the conversation:
Hi guys, any advise on how works with % completed vs planned % completed as smartsheets only has column for % completed?, has anyone achieved to make a similar column for planned %?
Hello,
You can create a new text/number column in your sheet and format it for percent. Details on formatting columns for percent can be found in our Formatting Options help article.
If you need planned percent complete to be calculated for you, you'll need to create a formula in Smartsheet that does this. You can find the complete list of functions here: https://help.smartsheet.com/functions
Hello, I'm working through the writing formulas optional activity and in the 'Nested IF function - Progress Column' task it directs you to put in the following formula '=IF([% Complete]@row = 0, “Empty”)'. However, when I put this formula into the spreadsheet, '04a_Marketing Request Tracker - Formulas', I get an…
Currently Triggering recurring workflows are only supported at the top of each hour. For instance 10:00, or 11:00, etc. Would like the ability to set 10:30 or 10:45. Perhaps the inteface can stay hourly so it doesnt get huge, but have the ability to manually edit the time directly to any custom time.
I have an automation that has a condition where I am looking at the column "LEA Interco Supporting Site(s)" and trying to find columns that have the value "Fort Loramie" in them. This works well when "Fort Loramie" is the first item listed in the cell, but it doesn't work when "Fort Loramie" is the second or third value in…
