-
Determine which Sheet / Workspace has been requested to be shared
Hi all, I received the following email. It notes that an external user has requested access to a Sheet. From the email, I can't determine where the Sheet is located (which Workspace) meaning I can't contact our PM to discuss whether they're happy for a sheet to be Shared. Can anyone advise how I can determine where the…
-
Proof column not showing up in my projects report
Because a picture is worth 1,000 words, I've included a screenshot to ask my question.
-
How can I reuse a Smartsheet Template every month?
I have a Smartsheet Template for Inventory that needs to be used every month by six (6) Users. The Template should start out as blank every month. The Totals will roll up to a Report. I can make six copies of the template, saved with unique names in a folder named for each month. I want to know if there is a better way to…
-
Request an Update with view only rights for some of the columns
Is there a way to send update requests that include view only columns and edit columns? Example: I have a document that has 6 columns of data, I'm looking for columns 1-5 as read-only and column 6 is open for edit? Thanks in advance for any options.
-
Alert Automation Comes Up In Error
Hello, I am having issue with an alert workflow where the workflow errors out. I have created a template for an internal process where we would create sheets to review and implement Deviations in our production flow. Upon creating a new sheet from the template and viewing the "Manage WorFlow" window, one of the alert…
-
Looking for some an "introduction to Smartsheet" slides/presentation..
Friends, I'm looking for the Smartsheet 101 / introduction slides or powerpoint. Do you know where I can find it? I searched, and could only find the reporting introduction (everything else was video). I want to use this as a base for new users before I introduce them to our standards and formats, etc. Thanks for any help!!
-
Formula Help - Deals closed in 2020
I'm working in the Summary Sheet and attempting to get a total of deals closed in 2020 for only 4 of the 16 business units I have in my sheet. I'm using this formula: =COUNTIFS([Business Unit]:[Business Unit], @cell = "Koala", Stage:Stage, @cell = "6 - Closed", IFERROR (YEAR @cell = 2020) This is giving me an error…
-
Moving Rows
If your sheet is linked to another sheet and you set up a workflow to move rows to a different sheet when a certain criteria is met, will the moved rows remain linked to the other sheet? Thanks, Wanda J.
-
Resource View
Is there a way that I can have the resource view displayed as a bargraph or gnatt view. Ideally I would like to group my resources by project with a 3 week outlook graph. Thanks Cindy Bowker Glastech Glazing Contractors
-
Formula not working (UNPARSEABLE)
I have the following formula that is not working. =IF(AND([TOTAL %]6 > 0, [TOTAL %]6 <= 0.1), "YELLOW" , IF(AND([TOTAL %]6 <= 0, [TOTAL%]6 > -0.1), "GREEN", IF([TOTAL %]6 <- 0.1, "PURPLE", IF([TOTAL %]6 > 0.1,"RED" The return I get is (UNPARSEABLE) Please advise if you can find the error in my formula. Regards, Derrick…
