-
#INVALID DATA TYPE
Hi All! I have two cells next to each other, Date Assigned and Date Due. When I add the date assigned date, I want it to auto populate the Date Due as 3 business days in the future. My formula works =WORKDAY([Date Assigned]86, 3) but when I have no date in the Date Assigned cell, the Date Due says #INVALID DATA TYPE. Is…
-
Scheduled Backup
I am trying to set up a backup on our main sheet (This one has info from other sheets linking into it) I am able to select schedule recurring backup for my entire workspace, but we don't need all of that. All we need is one sheet to be backed up each week. When I right click on the sheet it will allow me to request a…
-
How to select different image source (camera app) when adding photos
Hello- Is it possible to default to a different camera in Android app when selecting to take a photo. By default the smartsheet app uses Android camera. I would like to use Skitch so we can add notes, arrows, circles, etc. to the photo. We are using this for a production line checklist. THANK YOU!
-
Column Editing Restrictions
Hello, I have approximately 50 users that routinely review and update the data in columns in my SmartSheet. However, for 3 columns in my sheet, I need to restrict 47 of my 50 members from being able to update the data in those specific columns. The rest of the sheet can be updated by any user. Locking the column allows…
-
Specific Dates in Columns
Hello, I have a column that users must input a date that their project will attend a specific meeting. This meeting only happens on set days every month, so I am wondering if there is a way to only allow a user to choose/put a specified date in the cell for that meeting. For example, if that meeting happens on August 9th…
-
How often does a report update?
We are using a Smartsheet Report to upload data into a third party system. We are curious as to how often the Report will update. Example: If we open one of the Smartsheets that feed the Report and make a change and we do not open the Report, then when the third party system pulls data from that Report, will it have the…
-
task management...answer might not be as simple as question suggests!
Dear SS Fans, For many years I've been using a MS plugin called GTDOA. The joy of this PI is that at the point of sending an email I create an MS task, link the email to the task, tag to a category, set a due date, reminder date et al and then when I press send an MS task is created and I can forget about what needs to be…
-
Sending updates
Good morning, i am trying to send some updates on smartsheet to users that i have as my contacts, but they are getting the notifications about 30 minutes to 45 later. is there anything i could do to fix this?
-
Automatic Countdown
I am working on a restaurant buildout project list, and want to have a column for "Weeks till Opening Day" and another for "Days till Opening Day". Is there a way to have that automatically countdown to a targeted date?
-
If / Or with RGYG
Hi All I am trying to write a formula that shows whether a student is competent. Some units have 3 assessments (A, B, C) and some have 4 (A, B, C, D). I am using the Grey ball to show no assessment or N/A (for the units that only have 3 assessments). * 3 assessments - A, B, C = green and D = Grey then the student is CO,…
