-
Trying to find value text
I'm generating a chart by creating a metics grid for a tracking sheet. I tried using this formula and it's giving me the response, "UNPARSEABLE." This is what I used, "=VLOOKUP( {Tracking Sheet Range 2}"Q1_2020" @cell, "Q2_2020" @cell, "Q3_2020" @cell, "Q4_2020" @cell, false)" What I'm looking for is to find the triggering…
-
Is there a way to deal with "maybe situations" or varying predecessors?
Hi SmartSheet community! This may be an odd one to describe but I am going to try my best. I have a process that is a bit circular and is also a "maybe situation." For our product, we will go through rounds of optimization but only on an as-needed basis dependent on results. For example, we anticipate product A will need 4…
-
Helper columns vs #UNPARSEABLE error
This works for me using helper columns where I do count(parent) and count(children) =IF(OR(children18 = 0, Parent18 > 0), 1, 0) If I substitute the count(children) its #UNPARSEABLE =IF(OR(count(children) = 0, Parent18 > 0), 1, 0)
-
Add contacts to a cell
Any ideas or workarounds to add several contacts on a sheet to a cell in another sheet? I need to send an alert to the project team. I've shared the sheet with the project team but also with alot of other people who don't need the alert.
-
Time-tracker formula
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/Materials]$11, 2, false) * Hours1 When I remove the first entry which was a test, it messes up the calculation on the ones…
-
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?
