-
Smartsheet "Viewership" Access being denied!
Is anyone else experiencing a Smartsheet wide, all Workspace issue where unless your viewership is "Admin or Owner" you are unable to access sheets that you supposedly have access to? I've noticed the glitch "Fix" itself if I change someone's permissions from Viewer or editor to Admin, then put it back to their original…
-
Linking & Formulas
I would like the information from the first document labeled template first to auto populate into the second smartsheet labeled template second. I am managing multiple projects at once and have 7 smartsheets to track the data specific to each of those projects. I have 1 master smartsheet which houses meeting information,…
-
At Risk Flag - Past Due
I want to use the "At Risk" Flag to populate when an item is not marked complete and is past due. I assume I need to use an AND or and OR formula - but this isn't working. The formula below yields no populated flags. The line for "Tag Drawings" should populate a flag because it is past due and is not completed.
-
Next deliverable date based on TODAY
Hi Many thanks in advance to start! For each row i have a listed task with a column called Period 1 with a date and a checkbox next to it than when checked marks the date green. Each date represents when that task is next due. Extrapolate that out across the row and i have many dates for every interval the day is due, ie…
-
Sheet content, shifting rows
Oh boy I have a good one today. Please Help! On Friday I was working on my data base sheet, linking cells in a couple different columns to another sheet. (I hid the columns in between, to make it easier). Today, I noticed that the columns in between have shifted down a few and the further I get down them worst it gets…
-
Filter not Working: Is not in the last (days)
Hello, I'm drawing a blank on why this filter is not working correctly. I process the archive of the data in this log and will archive every week the items that are 21 days or older. This is how I have my archive set up and it always returns items that were submitted today (which most certainly does not meet my filter…
-
Isolating Reports & Linking from sheet to sheet
We have a data base of Subcontractors, that is created in a sheet. I am trying to have a tracking sheet (Bid/Contract Request) from bidding to contracts per job and per subcontractor. I have a column of subs that I have linked from the data base and then a column (checkbox) per job. Then the superintendents will go to this…
-
How to auto-populate/insert 10-15 task rows as child items under new project row?
What is the best way to automatically insert a set of (about 10) rows as child tasks under each project row? I am designing a smartsheet based on the Project Sheet template, but in my case we manage a large number (about 150) of projects. Each project is fairly simple: each project contains the same set of 10 tasks. I want…
-
Approval: two users/same level
Hello, Is there a way I can send an approval form to two managers who both need to sign off on each staff member's annual leave? I can do it if I send to Manager A first and then Manager B once the first step has been completed, but wondered if there's a way to do them both at the same time that I'm not seeing...?
-
Blank Rows in Gantt - Automatically get populated by start date
In Gantt format - I leave some rows blank to separate workstreams or buckets of work. But for whatever reason - Smartsheet goes and fills just the start date automatically in these row. I delete them, and then after I save, they come back again. They are harmless, but misleading and hurt the aesthetics of the chart. How…