-
Average days returns 1 value if 0 and the average value if >0
I'm trying to have the value of a cell say same day in the event the average number of days is 0. I want to return the average number of days id greater than zero. Everytime I add an else statement it becomes unparsable. Here is what I have. =IF(AVG({Field Scheduler Test Range 1}), 0, "Same Day", (AVG({Field Scheduler Test…
-
UPDATE IMMEDIATELY DataMesh Frequency not updating without running manually
I have several datameshes that are set to "run immediately" and "copy and add data" and for some reason they only run when I run them manually from the datamesh dashboard. I have tried refreshing the source and target sheets several times, waited a half hour, refreshed again, etc and nothing seems to get them to update on…
-
Summary Fields: Percentage of Completed Checkboxes
I'm very new to Smartsheet and hoping someone can help me. I have created a checklist, with different categories divided up by parent rows, and the tasks listed as children under the categories. I have a checkbox column and each task (in the children rows) has a checkbox. I have figured out how to calculate the percentage…
-
Populate % Complete when Actual End is a date
I want to populate the % Percent field with 100 when the Actual End Date is entered. I tried this formula but I get an error. =IF([Actual End Date]@row > "0", "100", "0") Any suggestions?
-
Login and toggling between sheet very slow
Just wondering if anyone has experienced similar issues, on login we are experiencing very slow response time, once logged in we are also experiencing delay when toggling between sheets. The curious thing is that this is only happening on one of our computers (iMac) the rest of the computers do not experience this issue.…
-
Inventory
Is there a training video to show us how to do the inventory and features? We want to use this feature but I need some training.
-
Forms - request comments and attachments but don't display current
Hi - I would like to be able to create a form in which new comments and attachments can be submitted - but previous comments and attachments cannot be viewed - is this possible? thanks
-
Count Unique Values
I have a master sheet that is essentially a list of all the schedules we currently have dealing with projects. Each project has its own project number. All i am trying to do is get a number of the projects we have scheduled to compare to the actual number of projects we have in our queue. Now for the tricky part. Some…
-
Smartsheet forms are still not WCAG complaint :(
I found that Smartsheet forms fail WCAG compliance using the WAVE tool due to the logo image lacking an alt-tag. In April, I asked about adding alt tags without success. Failing WCAG is a deal breaker for my organization. Is there any plan to add alt tags to the logos on forms?
-
IF Statement to set a symbol to a value - #Incorrect Argument set
Good Day, I am trying to set a Symbol value using this IF statement but I get a "#Incorrect argument Set =IF([Prev Year Difference]3, =0, "Unchanged", IF([Prev Year Difference]3, <0, "Up", "Down")) The column/cell that I am using the formula in is defined as a "Symbol" using the "3 Direction" Up, Down & Unchanged. See…
