-
Reports Malfunction
Hi, Are reports malfunctioning with anyone else today? I thought I was doing something wrong until I read the past community posts suggesting prior issues with reports. /-RI
-
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?
-
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…
-
Row Update vs. Added Alerts
I specifically set up an alert rule to notify me when rows are updated in a sheet and intentionally left added unchecked, but Smartsheet treats adding a row as an update and sends me notifications every time a row is added. Please correct this issue.
-
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
-
Sharing folders
Since Workspaces is not conducive to individual permissions, we are trying to use the standard folders under "Sheets". One department has close to 100 files in Smartsheet. We want to use Smartsheet in other departments as well, but would like to organize the departments by folders. With each Sheet, Report, and Dashboard…
-
Extracting data or finding information through several sheet
Hello everyone, Let's say that I sell the same product through several projects. I would like to know how many of that product I have into my pipeline this week. Can I extract this information ? I know I can do it with Excel ... Thanks! Elodie
-
New users - unable to submit new tasks
Hello, We are currently setting up some new users on our Smartsheet user list, however I am struggling to work out how to allow them access to submit tasks to our sheet. I've shared the sheet and they have the "web form" screen but their name isn't appearing on the dropdown as a submitter. Please could someone tell me…
-
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…
-
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?
