Auto Date Calculation/Auto Fill Date

styless

Hello, I would like the "Referral Bonus Payout Date" to return a date that is 90 days out from today once the "Referral Bonus Amount" and "Referred By" fields are filled in. Is it possible? Please advise. Thank you!

David Tutwiler

Sure thing:

=IF(AND([Referral Bonus Amount]@row > 0, [Referred By]@row > “”), [Start Date]@row + 90)

styless

Looking for formulas to input into the Referral Bonus Payout Date column.

David Tutwiler

I think this will do the trick:

=IF(AND([Referral Bonus Amount]@row > 0, [Referred By]@row > “”), TODAY(90))

styless

https://community.smartsheet.com/discussion/comment/266259#Comment_266259

Hello @David Tutwiler, thank you so much for the help! It worked wonders. Just a quick addition, say I added a "Start Date" column, how can I change the formula to count the 90 days from the start date?

Example:

David Tutwiler

Sure thing:

=IF(AND([Referral Bonus Amount]@row > 0, [Referred By]@row > “”), [Start Date]@row + 90)

styless

@David Tutwiler - Thank you so much for the help, I have learned a few things around here. I appreciate your time!

David Tutwiler

No problem. Glad it's working.