-
How can I embed a .mov from GDrive to Dashboard without an error message?
I was able to get the embeddable link for the file on GDrive, but when I try to input the link to a Web Content Widget, I keep getting the same error message. The article it suggests for help is not helpful in "checking the link", and I'm not sure why it will not accept it. The permissions on the video are open - anyone…
-
Problem with saving Sheets. Is there a list of error codes?
Smartsheet is frequently refusing to save changes in my sheet. It gets to the point where I have to save after every change I make to the sheet, and will be forced to reload (and lose changes) after every other change. The dialog box with further information mentions error code 6. Is there a list of error codes and ideally…
-
Why do I get a #Incorrect argument set error with the formula below/
=IF(Status@row = "Not Started", "Blue", IF(OR(AND(TODAY()>[End Date]@row, Status@row = "Not Started"), AND(TODAY()>[End Date]@row, Status@row = "In Progress")), "Red", IF(OR(AND(TODAY(-5)>[End Date]@row, Status@row = "Not Started"), AND(TODAY(-5)>[End Date]@row, Status@row = "In Progress")), "Yellow", IF(Status@row =…
-
Automation between two sheets
Hi All, Hope you're all well. I am wondering if you can help me. I have two separate sheets - one of them is the tracker and the other one is the RAID log. There's one column that's same for both sheets - it is a job number. All the issues gets submitted to the RAID log through the form. Is there a way to create any sort…
-
How can I stop a column being deleted when row is moved to another sheet?
We use multiple sheets for different stages of our business. The rows are moved from one to the next when triggered. However, one of the sheets has been set up with columns deleted, not hidden. Can I get these columns back? I know the rows in the sheet currently won't have the information reentered but I would like it on…
-
Is there a way to display a gantt chart in a Work App?
Hi there, I'm adding a page to my work app that displays a sheet. I can't seem to find a way to get the gantt within the sheet to display. Is this not available?
-
Query String to pre-fill a form
I am attempting to use JOIN to build a query string and I am able to do it however if the column I join has spaces in the entry, the JOIN only attaches the first word until there is a space. =JOIN([Join Column]@row:DlrName@row, "&DlrName=") results with a query string but only the first word in the column DlrName. How do I…
-
Multiple predecessors overriding eachother
Hi, I'm having an issue where it seems that when I add a 2nd predecessor, it overrides the first. I am wanting item #10 to start 1 day after item #4 finishes, and to finish 1 day after item #9 finishes (and therefore the duration will just auto calculate). Based on this I have added the conditions 4FS + 1d, and 9FF + 1d,…
-
Access Issues with Smartsheets?
Hi All, I have a paid license on Smartsheets and need to invite free users to certain spaces/documents to collaborate on work documents. However, when I share to users (both free and paid) with admin or editor access, they can't edit the document and have the 'view-only' version. I've tried contacting Smartsheet with no…
-
How can I create a chart based on two non-numerical fields?
Hi there! This is probably very basic stuff, sorry for that. I'm struggling to get some basic charts from a sheet that contains some fields related to project (Name, Project Mgr, Project Type, Health(red/amber/green)...) This is my sheet I'd like to have a chart showing how many red, amber or green each Project Mgs has.…