I'd like a column to populate "late" based on whether another column has a date in it or is blank. Does anyone have any experience with nesting this type of formula?
=IF(OR(ISBLANK([column name]24), ISDate([Column24])), "Late", "")
Try this... you need to replace your column name you're checking for the date in and set it up for the right row number. This for row 24.
My current formula is =IF([To whom will the sample go?]@row = "Customer/Shipped out", "Shipping Date: " + [Date to be Shipped]@row + CHAR(10) + [Ship Method]@row + CHAR(10) + CHAR(10) + [TR Full Contact Info]@row , "") I need this to be able to look at [TR Full Contact Info]@row and if blank, pull the information from [IN…
Hello, Can a combination of the INDEX(COLLECT and NETDAYS Formula be used to get the number of days between two dates in the same column? I want to get the number of days between two dates on the same sheet, in the same column, that have matching names and different project types. For Example: Studio Name is equal to…
I am trying to pull a phone number and email from our master roster that is on another sheet in Smartsheet. I cannot figure out the formula. This is the formula I have tried. =INDEX([EMPLOYEE NAME]@row , MATCH({IMS Master Roster Range 2}), 0)
