-
The dollar sign isn't showing up on my time tracking form
I download a time tracking form from smartsheet, but however I have 2 issues. The table for some reason does not have the dollar sign attributed even though i'm using this formula =VLOOKUP(Activity1, $[Task Name]$5:$Activity$10, 2, false) * Hours1 I would like for each form entry to start below the previous entry instead…
-
IS AND OR
=IF(AND((([Asset Type]113 = "Success Story"), OR([Asset Type]113 = "Video - Client")), Ancestor113 = "2"), "1") Trying to populate "1" where Asset type = Success Story OR Video - Client AND Ancestor = 2 THis throws an UNPARSABLE error. I think it may be related to my parenthesis
-
Week number @row function
Is there a more efficient way I could write this formula? I'm looking for the week number and I physically have to go in and change it for each cell. I would like so I can just copy down the formula. Also, a more efficient way to report down the date for the start of the week without having to manually pick it for each cell
-
How do I include Contact List Columns in Concatenation?
I need to create a primary key on a page that includes 3 text columns and 1 contact list. The formula errors when I try to include the contact list, but works fine without it. Is there a way to reference a contact column as text or get it to just read the name in the contact for that cell as text?
-
Countifs + Contains or Find Formula Help
I require assistance please to create a formula based on two criteria: COUNT "SPI Quoted Value" column, when >0 and when "Date" column CONTAINS or FIND "January" Therefore if I only selected the first six rows as example, the SPI Quantity cell would return the value of 4. I tried this formula, however didn't work…
-
Combine "Specific People" and "Contact in a Cell" in the the same approval action
When requesting an approval, I want to be able to send the decision to "contacts in a cell" and cc a "specific person". It appears I can only choose "Specific People" or "Contacts in a Cell" when determining the action from that approval. I have to create a separate workflow based on the population of the approval column.…
-
#Unparseable Error on Nested If And Statement
I have two columns I'm trying to reference in my formula, a check box column (Done) and a date column (Complete Date). Depending on the data in those two columns, I'd like a third symbol column update to Green, Yellow or Blue. The desired outcome is If Done is TRUE, then Green If Done is NOT TRUE, and Complete Date is…
-
#NO MATCH then it's fine, then it's #NO MATCH again
Hi, I have a VLOOKUP formula in my sheet, and it was working for days... then today I got a bunch of "#NO MATCH". I repasted the formulas and refreshed all sheets and re-saved etc... This fixed some of them but I still have many "#NO MATCH". Then, I copied the text of what was being searched... into the original reference…
-
Formula to Count Check Boxes in a Check Box Column
Trying to count in coumns how many boaxes are checked per column - Keep getting Boolean Expected. There are the formulas I have tried: =COUNTIFS([Mike M]5:[Mike M]135, 1) =COUNTIF([Mike M]5:[Mike M]135, 1) Is it possible to created this type of formula?
-
Health RGY Formula
Hello All, Our team has created the below formula which worked UNTIL we added the bolded part below. We cannot figure out what is missing and we keep getting an #Incorrect Argument Set error when we change the End Date to be anywhere between that 10 & 30 day range. =IF(AND(Status@row = "In Progress", [End Date]@row -…