-
Reassigning tasks in bulk to a New Resource
Hi, I have assigned multiple tasks to Jane, but I a new person is now taking over all of Jane's tasks. So is there a way I can bulk assign all the tasks and the sheets to the new person? Thank you!
-
Count of All Items, where Start Date is less than Today
Hi, I am trying to get a count of all Task Named: "To Do", where "Start Date" is less than Today's date. I am using: COUNTIFS(Task Name, "To Do", StartDate, "StartDate < Today()"), for this, I keep getting '0', but I see there are at least 4 tasks meeting this criteria. Any help if very much appreciated. Thank you, Deepthi
-
Sheet automation with a mix of relative dates and date ranges
Hello, One of our teams is using Smartsheet for team calendars, tracking things like time off, travel, working from home days, etc. Key notification criteria is based on start and/or end dates. Currently, their notification is setup to trigger when the start date is today. This doesn't catch when there is a date range…
-
Issue with iPhones taking photos with forms
I've been trying to find a solution to this but I'm coming up empty. Long story short, we use a Smartsheet form through a web browser on a phone to collect information. It's sort of an inventory process. At the bottom of the form there is the option to submit files or photos in which we take photos to document different…
-
Gantt View Timeline Zoom
I want to be able to view my gantt chart more zoomed in. Is it possible for me to have my primary headings as days and secondary as hours? Or is the furthest you can zoom in weeks and days?
-
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…