-
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…
-
Use "Created By" auto generated field as a "contact list" for use with approval workflow
I have a form that is use to submit travel requests. I would like to set-up an auto-field that captures who the form was "created by", rather than having them enter their name into the "contact list". I was hoping to use this to then send an auto-generated workflow to this contact. However, I believe workflows only work…
