-
Critical Path Won't Display
Hi, I have a sheet that refuses to display the red critical path. I've been up and down the sheet looking for missing links and parallel scope and I still can't figure it out. Can someone please help?
-
Source Report Unavailable
Is there any way at all to find out what reports were on this dashboard?
-
Do Update Requests ignore row locks
I am using quite a few workflows to automate a sheet. There can be situations where a row Update Request has gone to someone and before they respond to it another action causes the row to be locked. We've tested this scenario and it seems that the Update Request can be completed and the row is updated even though it is…
-
I am trying to add a hyperlink to an address in a cell that can take me to a pin in a Google map.
How do I add the cell value that contains the address in the hyperlink so that, when clicked, it will take me to that address in the Google map vs. just an opening page which shows my current location? I have hundreds of cells with different addresses which I would like to add hyperlinks to so adding each address with it's…
-
Combine columns in destination sheet based on record ID
Hello On Sheet A sheet I have Record ID column, then column A, B, and C. All columns are text/number. On Sheet B, I would like to match and combine columns A, B, and C based on the Record ID. Please see example: I've tried INDEX/MATCH and JOIN formulas, but keep getting #INVALID VALUE errors. =INDEX(JOIN({Address:Zip},…
-
Hidden Fields and Update Requests
Hello! Can someone give me an overview of the most practical application for using a "hidden field" on a form? I was trying to figure out if this would be helpful when I am trying to gather information from a stakeholder after they filled out "Part I" of the form- which we only ask questions about half the data I want to…
-
Where is attachment saved
I have a form where people can submit attachments. I can access the attachments in the smartsheet, but where are those attachments saved? Privacy is a concern so I want to be sure we are being as careful with materials as possible.
-
Forms and QR codes
Just wondering if any of the following are possible. Can I set up logistics within a form? For example, I want to create checkbox options that depending on what the person checks, a new field will appear. That way, people are only filling out what pertains to them and all other columns are hidden (and will only show up if…
-
Workflow activation bug
Hi all, I have created a workflow, where, when any changes are made to specific columns ( E.g: Project Name, Category, Department, Funding) within a sheet, and another column named "Reviewed?" (which has a dropdown list Pending, Reviewed, to be discussed) is changed to Reviewed, it should generate an alert to specified…
-
I need help with automation email notifications.
How to I fix this?