Hello, I have a time-tracker and have 2 problems: For some reason the total isn't calculating. It just calculate 1 hour. Here's the fomular i'm using =VLOOKUP([Talent/Materials]1, $Rate$5:$[Talent/Mat…
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?
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)…
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…
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?
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 …
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 gr…
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 sm…
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 h…
