Auto Date Calculation/Auto Fill Date

styless · 10/15/20

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 · 10/15/20

Sure thing:

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

styless · 10/15/20

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

David Tutwiler · 10/15/20

I think this will do the trick:

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

styless · 10/15/20

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 · 10/15/20

Sure thing:

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

styless · 10/15/20

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

David Tutwiler · 10/15/20

No problem. Glad it's working.

Auto Date Calculation/Auto Fill Date

Best Answer

Answers

Help Article Resources

Categories