-
Conditional reminder
Does this send an alert ONLY 30 days out, 20 days out and 7 days out - or every day that is less than 30, less than 20 and less than 7? I want to send a reminder to complete a task ONLY 30 days before the end date, 20 days before the end date and 7 days before the end date conditioned on the task being a milestone/not done.
-
Descendant date formula
is there a way to return the oldest/newest date of the descendant dates. for example, if the parent cell is the name of the project I want the start of the project to match the earliest date found in all of the sub task dates, and the end date of the project to match the last date found in all of the sub tasks Thanks for…
-
Date isn't today <> ""
Hello, The below formula was suggested by the community experts, but I had a follow-up questions: =IF([Target Start Date]@row <> "", IF([Target Start Date]@row <= TODAY(365), "Advanced", "Experts Only")) What is the purpose of the first part of the formula where it says, "IF([Target Start Date]@row <> "". Why do we need to…
-
Complex formula is calculating random cells and skipping others.
Hi everybody, So this will be a long read, but i hope somebody will help me solve this craziness, that already ate 2 days of my life. So i have this formula: =IFERROR(IF(VLOOKUP([Seller]1; {Range Seller | Bonus}; 2) = 1; IF(VLOOKUP([Sum]1; {Bonusai Range 1}; 2) < 1; [Sum]1 * VLOOKUP([Sum]1; {Bonusai Range 1}; 2);…
-
Can I importrange data from a Smartsheet into a Google Sheet?
Hi There, Is it possible to have an importrange in a googlesheet that is pulling live data from a Smartsheet? This is what I am trying to achieve: We need to implement a consultant request process. Requester fills out form with all necessary information, that is routed for approval from Ppl Ops, Finance, and Dept. Head,…
-
Return null if there is no date
Easy question: in the formula below, I need to add a final (or starting?) condition that if there is NO date in the Due Date column that no colored ball will appear. Right now, if a task is added and they haven't put in date it is showing Red and that is throwing the metrics off (as the metrics are looking for the Red…
-
How can I make other categories fill after a name from a dropdown has been selected.
I have a form for users to use that looks like this: I would like to make it so that when a user pulls their name from the the drop down menu "full name" their email address and phone number are automatically populated. I was thinking I could do this with vlookup from another smartsheet, but I am having problems getting it…
-
sheet summary, countifs task status
I have a simple formula, i can't seem to get working. reads - invalid data type In the sheet summary i want it to count the task status, (Red, Yellow, ...so forth) When i put in specific range ie [Task Status]2:[Task Status]100 - it seems to work fine. but when i wish to calculate the entire column. (*some rows may be…
-
Flagging Parent, if Child flagged and if parent % complete = 1
I have a project management sheet set up for % complete not using the sheet logic, but using formulas so I can have them fed by check boxes. I also have a manual 'star' flag so I can make notes (if something is done, but waiting for feedback) that turns yellow to remind me to look at it. I am looking to flag the parent…
-
Averageif Formula
Hello All, I need your help to define a formula, I have Country column and Networkdays columns so I need to avg networkdays for the specific country. could you please help me. I am using : =AVERAGEIF({Table 1 Range 12}, {Table 1 Range 1}, ="France") But I am getting : Invalid operation so basically I am not able to give…
