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)
Card/Board view doesn't show Assigned To column as an option for grouping items. Some possible causes that I've already checked: There are no rows that are empty in the Assigned To column Rows with multiple assignees have also been converted to one assignee only The Assigned To column is of the Contact type The assignees…
Has anyone had any luck or figured out a work around to include attachments in the body/message of the email? I have received feedback from recipients of the emails that it would be more efficient to be able to download the attachment directly from the email, rather than open an update request, open the file, save the…
I have a number of published sheets, and in recent weeks the bar just below the sheet name, which contained the print icon, the view drop-down menu and the highlight changes icon have disappeared. I haven't done anything on the back end to the underlying sheets. Unfortunately I've put a ticket in for support help (on about…
