-
How to set up an automation that is based on an if statement?
Hello! I am trying to set up an automation that changes a cell to "Complete - Pass" when four different conditions are meet. The way I am doing this is by adding and additional column that does a pretty complex if statement, and from that it either returns "Pass" or "Fail". =IF([QA Filter FAIL]@row = "Fail", "Fail",…
-
Best Approach for Forecasting Resource Availability in Smartsheet?
-
Daily PO Status tracker, with visual alert, if delay in any of multiple department's queues
Need to combine multiple department's reports into I'm assuming a dashboard that visually shows the status of the parts on order for the PO with status of the queues after flipped to an order. I can't figure out how to push daily status of the parts on order for the PO to a central report, but maintains the history of the…
-
Resource usage reporting at project level - warnings of over allocatoin
Can a view of a project plan be developed to show the allocation of a resource within the project itself. It should report when the project itself has over allocated a resource due to multiple activities using the same resource over the same time period. A view Similar to that in MS Project would be ideal, where you can…
-
Why automation copies the row 3 times instead of once?
Hi everyone! On Smartsheet, I have a source file for which I created an automation. Through this automation, the 7 rows of the source file (whose values are updated multiple times a day) are copied to another destination file. According to the automation, the copy should only occur once a day at 4:00 p.m., and the goal is…
-
Embedding from the Calendar App
Is there a way to embed a calendar you created from the calendar app without placing it as a widget in a dashboard?
-
Merged: Sheet Banners
This discussion has been merged.
-
Milestone Trend Analysis (MTA) Chart creation on dashboard
Hello, I'm adapt/add a Milestone Trend Analysis (MTA Chart) on Smartsheet. Is there a way to reflect his on a dashboard. Here is a copy of what I would like reflected on our dashboards. Not my data but I saw this for usage with MSProject. I'm looking to have sheets with data and project/display this data on the dashboard…
-
See all the tasks an individual is assigned to across multiple sheets.
Hi Dev team, It would be great to have a widget or view that allowed staff to click and see all the tasks they are assigned to across multiple sheets in a single workspace. Something like a "My Tasks" icon on the left Nav that shows all assigned tasks that's available in MS Planner and other task management tools.
-
I have a "Current Project Log" with 2024 accounts. How do I move to "2024 Log" & keep dashboards?
Hello, Due to the size of our log I can only keep 1 year's worth of data in a sheet. I have monthly and YTD metrics/dashboards that pull from the current sheet. I need to move 2024 into a new sheet to make room for 2025 projects, but I know doing this will cause issues with the dashboards. Is there a way I can do this…