-
Parent and Child Status Formula
Hi, I'm hoping to create a Formula in my parent row to state if both child row's marked as complete then Parent row will automatically mark as Complete. Is this possible? Thanks!
-
How to check Finish date and %Complete to determine RYG symbol?
Hi Expert, Seeking advice how can I come out with a multi-condition formula from 2 columns with below criteria? Say I have a column name %Complete and another column - Finish Date If %Complete not 100% and Finish Date is smaller than today(), show Red symbol If Finish Date is larger than today(), show Green symbol If Today…
-
CheckBox Formula
Greetings! So, I have a "Done" column and a "Status" column. Status column values = Not Started , In Progress, Complete Done value = Checkbox The Goal: When I check the "Done", I would like to have the Status column show Complete. I have partially achieved this with the following formula: =IF(Done@row = 1, "Complete")…
-
if / and / isblank formula
If my status is closed, but I did not put a date in the date closed column, I need it flagged. Can someone help write this formula? I am using =IF(AND(ISBLANK([Date Closed]@row), Status@row, "Closed"), "High", "Low") and get the error #INVALID DATA TYPE
-
Is there a formula that can capture the date when a cell changes?
I have a list of dropdown categories to capture the project stage and would like to capture the date when the project stage changes. I also have a list of dropdown categories with the project stage owners that I would like to capture the date of when this changes. My goal is to see how long the project takes on each stage…
-
Is it possible to send specific columns of two spreadsheets to a third one?
Hi everyone I have two spreadsheets and I want to take some columns of sheet 1 and others from sheet 2 and put them in a third one and that every time an update is made in sheet 1 or 2, it also apply on the third one. Including new rows, deleting rows and changing data. I am working with many data. Thank you, Belia Báez
-
Is it possible to create a personalized email format?
Hi everyone, I want to send an automated email from Smartsheet with some specific information, but I want to give it some specific format to the email just like if I send it from outlook. Thank you
-
Multiple Selection - Formula
Hi - I have a question re: a Multi-Selection Drop Down. Right now, our one multi-select has 120 options. More often than not, people select less than 5 from the drop down. When they select from the drop-down, I have to parse what they select into codes. E.g. - Selection 1 = Code 3, Selection 2 = Code 10, etc. I'm using the…
-
Can I use VLookUp if what I am looking up is a range of dates?
I need to cross check an entry in my smartsheet with a range of dates against another sheet. I am able to do a Vlookup for start date (first pic below) but am stumped on how I can get it to look across the range of dates I need (start date to last date). I think I need to use another formula but am unsure on how to express…
-
Change values on TableA based on a change/correction request on TableB
Hi All, hope all is well. Currently I am working on an attendance tracker model, which will be used as a data table. The users will have predefined values on TableA for the whole year, which means that based on those everyone works every day during the whole year (which we know that isn't the case), so users need to submit…