-
How do I set up a 'running date column'?
Similarly to a running total, I am needing to have a running date. So that every day it will move and change based on 'today'-- and referencing my start date column. How do I set this up?
-
How do you expand the height of a row?
How do you expand the height of a row?
-
Formula Using IFS, Contains, and AND
I am trying to troubleshoot the following formula: =IFS((CONTAINS("Shadow", {GI Clinic 3 Session})), AND([Provider Last Name]3), "Scheduled") Logic: If the cross-referenced sheet (GI Clinic 3 Session) contains the word "Shadow" and the Provider Last Name is the name in cell 3 (current sheet), then say "Scheduled."…
-
Using dates without a date column.
Hi, Is there a way to use dates in formulas without them being in a date column? I am trying to reference a drop-down column that has some dates in it and then take 42 days off of them. Is there a way to do this without the dates being in a date column as it needs to be a drop-down column. Thanks, Liam
-
Auto-populate smartsheet template from form entry
I have a tracker smartsheet that has a form attached to it. When a new entry is submitted, is there a way to auto-populate a new smartsheet template for every entry?
-
Collaborator Name not Recognised When Trying to Apply a Filter in Activity Log
Hi, when looking at the activity log for one of my sheets I can see the names of the collaborators the sheet has been shared to. However, when I try to filter on one of the collaborators I'm met with the error message "Unknown User Entered". It doesn't matter if I use their christian name, christian name & surname, or full…
-
If(And(Or
I'm trying to create a formula that includes If, And, and Or in it and I'm having trouble figuring out the correct way to write it. Written out what I need is: If "restrictions in place through" is greater than 3/28/2020 OR equals UFN AND "max # of people.." is greater than 0 make "local ordinance status" yellow and If…
-
Create a work report
I have a Gantt of a project which has weekly minutes compiled of site meetings and others. How do I create a specific report that goes to the project manager and asks him to load specific copy onto smartsheet?
-
HELP with a large sheet and table layout/conditional formatting
I spent 15 hours trying to organize my data in an efficient way and just can't come up with a good solution. Smartsheet is great but SO limiting if you are used to Excel. I have 200+ sites that each has 31 activities. Each activity has 3 dates - planned date, reforecasted date and actual end date. I need a report that…
-
Help With Adding More Conditions in Current IF Formula
Hi everyone, I am currently struggling to add more conditions to my current formula. The formula is: =IF('Department 1'[Approval Response]="Pending" && 'Department 1'[Past Due/Scheduled]="Past Due",1,0) I want to add two more conditions to the approval response: "In Process" and "On Hold", while keeping the second half of…