-
Need to calculate an Expiration date
I have a sheet that I have included the current inspection date. I need to calculate two expiration dates. One column @ 90 days post the inspection date and one column @ 365 days post the inspection date. Any help would be greatly appreciated. Thank you, Nicole
-
Error issue when trying to sync Google Forms
Hi, I just created a new form in google forms and when I try to sync with smartsheet I get this error: Error: Start Send (create sheet): Exception: No item with the given ID could be found, or you do not have permission to access it. Both google account and smartsheet are the same email address. I was able to sync a…
-
Ghost data from unused SCC template remains
I have three different gantts with some summary data that is fed into the main project data sheet. Only one of the gantt sheets is used in a project, so I thought of linking each of the gantts' data (exact same field/cell in each sheet) to a cell in the project data sheet - then just grab the one that isn't blank or an…
-
Predecessor Issue
Is anyone else having issues with the predecessors in SmartSheet? Right now, I have several sheets that have predecessors that have a duration of 1d and are following the row above without a 'type' (finish to start, start to start, etc.). As you can see from the screenshot, it has row 1 ending on 1/21 and row 2 start on…
-
Automatic forms generated from report display all main sheet fields on browser
I think I've found a bug: Automatic forms generated from reports in the browser (right click in the line mover on far left > edit) display all main sheet fields on it. It doesn’t matter what columns I have chosen to display in the report creator, but in the smartsheet android app the automatic generated form of a report…
-
Dashboard Charts are Blurry/Fuzzy
Hello all - I am building a dashboard and wanted to include a few charts. However, my charts come up fuzzy, regardless of size. See below. These are pretty nicely sized on my dashboard and still showing blurry. I saw from a post in Nov 2018 this was a known issue. Anyone else have this issue? Any fixes or updates? Thanks!
-
At Risk Flag
Hi there! I am trying to have it so that the flag shows if the End Date is 3 days away AND the Status is "Not Started" (ideally, I would like it to show if the status is anything but Completed, but that may be too difficult). I know to use a nested IF/AND function, but I keep getting errors when I write it out. I started…
-
Project Approval Received / Master Project Sheet Populated
I'm trying to setup an intake process where a new project is submitted through a form and appears within a project intake sheet for review/approval/denial. If approved, I'd like certain, if not all, column values for new projects to be copied over to a master sheet, which includes additional columns for project charter and…
-
Automatically enter category into cell
Sorry, I do not know how to say this. I would like to see if there is a way to automatically enter the category name into a cell. (see image) I've manually put the category in the highlighted box but I'd like to see if there is a faster way? Thank you