-
Losing form queries
Hi all! I asked support about this but I didn't get an answer yet, so I just wanted to see if anyone else had this issue. We're using forms with queries (passing default values to fields). It works fine as long as the user has accessed smartsheet at least once that day, and so single sign on is happening. But if they…
-
How to hide cards that are more than 30 days old
To track my activities, I utilize the swim lane method, which involves organizing my tasks into different lanes. However, I am facing an issue with managing my completed cards, as I have many of them. Specifically, I would like to hide completed cards that are older than 30 days, but the filter I tried to apply only shows…
-
Non-working dates changed
Hello. I am extremely frustrated with Smartsheet. I entered a set of dates as Non-Working Days for my projects. However when I edit the project plan a few days thereafter I noticed that I cannot set certain task end dates - only to discover that the non-working days have been changed. From the Activity Log I can see that…
-
Stacked Bar graph showing quarterly progress
Kia ora, I am trying to show progress on on parent tasks over the year based on quarters, i.e. Task 1 - Q1 = 59%, Q2 = 75%, Q3= 82% Task 2 - Q1= 10%, Q2 = 45%, Q3= 56% Task 3 - Q1= 100% I have colour coded each quarter and am only wanting to to show the current quarter % complete in the graph, thus showing % complete to…
-
New Row Added Workflow Trigger not working when non-licensed user adds row
Hi, I have set up a simple "When rows are added" workflow, but it only triggers when I add a row. Issue: when other users add a row, it does not trigger the workflow Example: Me (licensed-user/sheet owner) = User A X (non-licensed-user/sheet Editor-can share): User B Y (non-licensed-user/sheet Editor-can share): User C…
-
SmartSheet Proofing of dozens of files
Is there a way to bulk submit a few dozen files for proofing? Typically, this would be PDF engineering drawings. I want to start doing this within SmartSheet, but don't want to do them one at a time. Alternatively, can an automation be configured to copy the file for proofing and submit it to a group or group for review?
-
Workflow Automation changing cell contents
I have 2 'check' columns that indicate Start Confirmed and End Confirmed. I have 2 Workflow automations; When 'Start Actual Confirmed' is checked then 'Status' changes to 'In Progress'. When 'End Actual Confirmed' is checked then 'Status' changes to 'Complete' The issue I am running into is that when a user checks 'Start…
-
Dashboard Widget to show completed items by month and year
Hi all, I am trying to complete a dashboard item that was started by a colleague and starting to wonder if this is even able to be accomplished. Below are screenshots of what I am trying to achieve. I am grabbing a column from a sheet and want to display it on a dashboard widget.
-
I need your calculation support
I am trying to perform a sumif calculation. =SUMIF([Actual Savings]:[Actual Savings], [Actual Savings Start Date]:[Actual Savings Start Date], AND(@cell < DATE(2023, 3, 31), @cell > DATE(2023, 3, 1))) The first time it shows 0 as the value when it should be over 200K. The second time I typed in the exact same calculation…
-
i am doing cross sheet reference and am getting #INVALID COLUMN VALUE error, I don't know why!
It only happens with this reference only =INDEX({Start}, MATCH([Task Name]3, {Record}, 0)) if I change the value from {Start} to {client} it works and it gives me the value
