Sign in to join the conversation:
Is it possible to have .5% as a percentage. Whenever I put .05 it rounds to 1% and .04 rounds to 0%.
Thank you
Hi Kari,
Yes, it is! You need to adjust and increase the decimal. (see attached screenshot)
Hope that helps!
Have a fantastic week!
Best,
Andrée Starå
Workflow Consultant @ Get Done Consulting
Hello, In my source sheet I have a multiselect column called "Problem Code to be Updated". I am trying to use the reference sheet in the screenshot to identify if the multiselect cell in the source sheet has any of the problem codes where the "Technician Assigned Problem Code" is "Yes". The dropdown values are all taken…
Hello I know this might be very simple but I have tried everything to cross post a value from one sheet to another and I always get the wrong ref error or the unparseable one, this is the formula I'm trying to use, please help. =COUNTIFS({RE Projects Range1}, "Counter", {RE Projects Range2}, "Complete")
I’m looking for a cross-sheet formula in Smartsheet to calculate the average Turn Around Time (TAT) by specific Site Numbers. Source sheet details: Site Number (text/number) Turn Around Time (number; measured in days) Target sheet details: I have a row per site and want a formula in the Avg TAT column that returns the…
