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)
We want to implement single-sign-on at work and have received approval. However, our IT department wants all external partners to have/use Mayo credentials to log into Smartsheet. Not all of our external partners ever set foot on our campus and don't have our company credentials. I have a couple of questions. Has any other…
I can create a Chart in Dashboard from sheet well but from Report is not working now. I just try with simple Report (just contain 2 column Primary and Number) but cannot make the chart. Is there any changes recently right, because I haven't worked with Smartsheet dashboard for a long time and I remembered that I could do…
Cant find this anywhere
