-
Formula for Auto RAG status
Anyone help? Using formulas, you can automate RYG balls to change colors based on the Due Date being 45, 30, or past the due date? Thanks
-
Workspaces or Reports
Are there limits to the maximum number of worksheets in a report ? I have 97 in my workspace but the report builder will only report 96?
-
Retrieve deleted sheets
Hi, We accidentally deleted the sheets in our accounts, because we want to change the plan. Case number 02911830 Can you please help us how to get back the sheets that were deleted from "deleted items"? Thank you, Divya
-
Importing output from excel to populate smartsheets
Good afternoon all....I have built a pretty involved excel spreadsheet that was originally to be used as a quick price quote tool for a print shop. Input is required for Material, size and quantity which will generate a price for a single and/or double side print. We currently manually enter each of our workorders into…
-
Invalid recipients in Alerts and Actions rule
We have lots of alerts/actions/notification rules setup across lots of sheets. When I delete a user due to employee termination, then I get this message: "Invalid recipients in Alerts and Actions rule" I don't want to have to dig through dozens of sheets to remove the people, how can I do this on a mass scale?
-
IF AND ISBLANK formula
Hi, I want a RGY to turn Red if we are "pass" our target date, yellow if "at" the target date, and Green if "before" our target date, =IF(ISBLANK([Target Date]1), "", IF([Target Date]1 > TODAY() + 1, "Green", IF([Target Date]1 >= TODAY(), "Yellow", IF([Target Date]1 < TODAY(), "Red", "")))) this formula works, except even…
-
Novice user, Build Reports
Hi. I have a sheet in which we enter transactions and the date they occur. I would like to generate a report that sums the number of transactions over a certain period. This report could then be emailed or accessed via URL, etc. Is this doable? Thanks!
-
Reports: Sorting groups of rows by the end dates of their respective master rows
Hello! I am hopeful that I can find the solution to this issue. This is a bit of a long one, so get comfortable! I am using SS to organize the workflow of active jobs at our precision manufacturing facility. Each job requires almost 100 independent job steps from start to finish. Each individual job task is on a separate…
-
Can your event span time in calendar view?
I am using Smartsheet’s Product Release Roadmap form. I added a start date and an end date to the cards so that the projects can span a period of time in the gant view. Is there a way I can make it so they also show as spanning a period of time in the calendar view? Currently, each individual card is only showing as the…
-
Consolidating identical project sheets
Hi all, for each of our project we have built a simple scorecard that lists milestones / tasks on the left column, start/ end date, status, health. This scorecard is identically used for all projects since we have same deliverables for all our projects. Ask: how can we have consolidated view for all our projects in one…
