-
Show columns in multiple sheets that are unhidden - using a report?
I have over 300 sheets all built from the same template. That template includes admin columns that we like to keep hidden, but sometimes users may unhide these by accident. Is there a way to make a report from all of those sheets, and determine if certain columns are unhidden and I should go in and edit those sheets?
-
Proofing Automation
How do I use the workflow automation for approval with Proofs? For example, I need to send a PDF proof through a workflow to be approved, but I am unable to do this through automatic workflows (cannot add a Proof) nor the Proofing feature, which is not automated. Also wondering if I can use dynamic cell data in Proofing…
-
report for Gant Chart
Is there a way to show the progress of a task on the Gant Chart on a report? I know you can do it on the sheet but don't see it on the report. I can use label to have the % complete but not the progress bar? Any help
-
Milestones
is there a way to color a milestone?
-
Can free workspace collaborators edit dashboards?
Hi there, We're fairly new to Smartsheet, but we are already using it to create new business opportunities. We are creating dashboards for a client, and we have set the client up as a collaborator on a client workspace. However, the client is being blocked from editing the dashboards that we have created for them (see…
-
Links in Dashboards
Hi, What are my options while creating a dashboard to linking to other smartsheet items? I see I can use "widget behavior" with charts and images to have it link to a another smartsheet item - are those the only widgets that you can do this with?? I would like to link either a rich text widget or Title widget. I got the…
-
Checkbox Conditional Formula
I'm trying to have a checkbox column automatically checked when the percentage of another column on the same sheet is greater than 5%. I've searched these community posts but only seem to find a formula when text falls into one field a box is checked and not when a number or greater is reached. This is the closest thing…
-
Data validation for multiselect dropdown lists?
I am embedding a Smartsheet form in an online training module, to collect and validate the answers in the absence of an LMS. For a single dropdown, I found it easy - I create a question column, in which I collect the answer, and an answer column, in which I validate the answer. To validate the answer I use a simple IF…
-
Remove "In Progress" from formula, but comes back unparseable
Good morning! I would like to change the behaviour of the below formula that defines rag status... =IF(Status@row = "Complete", "Gray", IF(AND(Status@row = "In Progress", [Due Date]@row > TODAY()), "Yellow", IF(Start@row > TODAY(7), "Green", IF([Due Date]@row < TODAY(), "Red", "Yellow")))) I would like to remove the…
-
International Holidays
In MS Project you're able to apply a calendar to a specific task. I understand you can't do this in SmartSheet but I'm wondering how people get around that? We have to consider China holidays and we typically just apply a non working calendar to that part of the timeline so that we understand the delay. Surely there are…