-
Workspace & Sights
Hi all. I was wondering if there is a way I can copy a dashboard (Sights) to more than one workspace or folder? For instance, I have multiple workspaces that hold reports, sheets, and dashboards based on category (audits, projects, document updates, etc) and I would like to store the dashboards in their respective…
-
How do I access my account so I can pay my subscription myself?
Hello everyone, I hope you're all doing well! I was using a premium account paid for by the parent company administrator, but they didn't pay this month, now I'm at home and I can't access smartsheet, it gives me the message in the screenshot provided. My supervisor asked me if there's a way to pay myself for this month…
-
Quickly Re-assign row assignments to another user
I have a lot of projects on separate sheets within Smartsheet which have rows assigned to users. If the user leaves the company, I can reassign that user's sheets to another user, but is there a way to re-assign the rows they are assigned to?
-
Skip blank cells with YEAR function
I’m endeavoring a roll up sheet that will provide sum totals from a single row on a separate Planning Request sheet. If the source sheet has all cells filled out, the formula seems to work fine: =SUMIFS({Planning Request Range 2}, {Planning Request Range 1}, [Member]1, {Planning Request Range 3}, "Approved", {Planning…
-
Sharing segments of a Form's responses
I am looking to share only select results of a Form using a Report, but, in order to do so, it appears that I would need to provide access to the initial Form results. Is there a way to avoid doing that so that the person cannot see all of the form's results (i.e. departments other than her own)? The Report doesn't…
-
Task auto-assignment breaking when projects are manually reassigned
I have a form that the team uses to request work. Once the form is submitted, a vlookup assigns the task based on criteria entered in the form, and that team-member is notified of the work request. Works great. However, the manager of the team sometimes has to manually re-assign work due to work-load issues, etc. When she…
-
Smartsheet formula
Hi Can you please suggest me with a formula that carries out the following function for me: IF %column = 100%, "Complete" IF%column = >25% and <=99%, "In Progress" IF %column = <25% "At Risk" IF %column = blank, i.e. no value then "Postponed"
-
Auto-populate multiple cells with hyperlinks to web pages based on the value of one cell?
I have a sheet serving as a software upgrade checklist template "model", (not an actual template, because it contains cross-sheet functionality, which is lost in templates). The sheet includes rows of tasks and a column containing hyperlinks to web-based instructions for each task. Instructions are on different pages based…
-
OR function Not Working with Multiple Logical Expressions
Hello, I have the following formula: =IF(OR(Status4 <> "Complete", Status4 <> "Sent/Complete"), "not complete", "Complete") which always returns "not complete", i.e. true. However, modifying the expression so that only 1 logical expression is present, the expression works correctly, showing the true and false outcomes as…
-
Date Created System Columns
Hello! I'm in need of some help with something that seems so simple but I'm going in circles. I was using a form / sheet to track responses for a program that runs quarterly. Standing up a new form / sheet quarterly was becoming an issue so we moved to a database format - ie. every response on one form / sheet regardless…
