Sign in to join the conversation:
Hi all,
I try to add colomn for % of theoric progress and use it with the real progress on formul to define different status (Done, Not Started,Task in Overdue, Work in Progress)
Hi Adil-Dkaki,
Smartsheet treats percentages as values between 0 and 1. For example, 0% should be expressed as 0 in a formula, 75% as 0.75, and 100% as 1.
Try converting your percentages into decimal values in the formula (make sure to remove the % sign as well). Here's an example of the formatting using a small chunk of your formula:
=IF(TODAY()<[Columne]5, 0)
Hi Everyone, I am managing a pipeline tracking sheet, and there's one intake form and one dynamic view connecting with this sheet. For the column "Branch Contact" and "Sales leader", I set the filed type as "Contact list" and the validation as "No validation". Once I input the username in the intake form, I go to the…
My email is linked to two smartsheet platforms - one for the organization I work for and one managed by a contractor. I made a survey in the one managed by my organization but now I can't access it. I keep being taken to the contractor smartsheet.
I know there are multiple threads on this issue, but I thought I'd provide a thorough User Case: Win 11 v24H2 current updates Using Smartsheet desktop Source Report2 contains formula using data from program plan (Source1) Trying to build KPI dashboard using Report2 repeatedly get "Couldn't Save" "undefined - undefined"…
