-
Calculate days remaining until task due date
I'm trying to calculate how many days remain until a task's Due Date, but only if the Status is not "Complete." If it's complete, I want the cell to stay blank. What formula should I use?
-
Owner of the sheets but only have Viewer access right
I have subscripted Pro user plan and currently work on 3 sheets. Two of the sheets suddenly not allow me to EDIT and I can see I only a Viewer of the sheet, but actually I am the only member of the plan. Really don't know how to fix the access right to be admin of those sheets.
-
Moving rows to another sheet - Admin access
I have a very simple task list sheet. No timelines, dependencies, Gantt, %complete - just a list of tasks with status, priority and similar. When I set the Status column to "Complete", I want to (manually) move that row to an archive table with the same column set. A popup box says I need Admin access to move rows. I have…
-
Sheet automation notification email tracking using a PowerAutomate Flow and Outlook
This post details how to track all sheet automation notifications emails. This solution is medium complexity and will likely require you to use an AI for some simple coding. Smartsheet allows users to automatically send email notifications from sheets. There are a few significant problems with these automated emails.…
-
How to make a Static Sheet Form for Multiple Cells?
Basically I have a questionnaire template for projects that I created that I need as a sheet to allow people to enter scoring rubrics and comments into a master sheet, but the projects need their own static sheet in each cell of the master sheet. Is there an easy way of doing this without having to create a million copies…
-
Dynamic view time-stamp issue
I am set up in CET, and I set up a dynamic view where the time stamp column (time created) in the sheet is transposed to the dynamic view with a +6 hrs. This is kind of inconvenient… is this an issue that can be resolved? e.g. 12:01 pm appears as 18:01 in the dynamic view vs. 12:01, 11:40 am appears as 17:40 in the dynamic…
-
Data Mesh & Automated Sheet
I have a reference sheet that is connected to a more widely shared "Active Projects" sheet via data mesh. The reference sheet was created to be able to edit rows of the same project type in one sheet rather than dig through all active projects to make updates. The "Active Projects" sheet has an automation to be added to a…
-
Daily Automations
Are automations set to daily, based on only EOD data or compile all the triggers and send together at EOD? I'm looking for only EOD data and now sure how to get only that in my sheet.
-
Connecting Automation to conditional formatting
I am trying to figure out a way to attach automation to conditional formatting. For example, I have 4 columns, with the last one being a checkbox or another standardized trigger. I want to send out a notification that a row has been added, only when the checkbox in the last column is clicked. I set that up already because…
-
Weekly/Monthly Status Reports
Hello smarties! I hope you all are doing well. I have a new situation that I wanted to start with you all to see how you would handle. I have a new situation where we need to supply a Weekly/Monthly Status Report. I know that I could build this in a dashboard (I also plan to do this) however is there a way to "save" or…