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
Hi everyone! I need to set up an automation that is triggered within a set number of days before the date listed in a date field. I need the automation to send an alert email to a new hire at most 7 days before the start date. I know I can set the automation to send 1 week before the start date, but if the new hire's…
I’ve started building a form in Smartsheet using the Smartsheet Form Builder, and the responses are successfully populating my sheet. The challenge I’m running into is creating conditional logic within the form to narrow down selections. For example, if a user selects a state (such as Florida), I’d like the next question…
When I publish the calendar view, not all my tasks are showing up. I have all filters off. In my regular view on the sheet, the tasks are there.
