Sign in to join the conversation:
Is there away to get smartsheet to recognize scientific notation in order to add, subtract, multiply, divide, etc..
Thanks
Hello,
We currently don't have the functionality to interpret scientific notation within Smartsheet, but please feel free to submit a Product Enhancement Request to let our Product team know that you'd like to have this functionality in Smartsheet.
Hi community experts, I'm trying to flag projects that are at risk. A project should be marked "At Risk" if the Status is not Complete, the Due Date is within the next 7 days, and the % Complete is less than 80%. Otherwise it should show On Track. What formula can do this?
Hello, This might be somewhat of a long/confusing one. I am trying to figure out how to better automate categorization for blood pressure categories when being placed into a sheet. For example, in the image below the column "BP" is where the initial number is input. I then put a LEFT formula in the column "Sys formula" to…
I’m trying to set up an automation rule in Smartsheet where the “Status” column automatically changes to “In Progress” when the “% Complete” column is updated to a value between 1% and 99%. I noticed that there isn’t a “between” function available when setting conditions in the automation workflow. What is the correct way…
