-
Summing Data From Another Sheet
I have a resource tracker that is set up to sum hours by resource using the =SUM(CHILDREN()) Function. I also need to be able to sum hours by Project Code (Column 4), and Classification (Column 8) by Month. Can someone advise on the best way to approach this? My first thought was to use a SUMIFS formula -- =SUMIFS([Jan…
-
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…
