help with formula
Hi Everyone - I'm new to this community and wondering if I can get some help with writing a formula to do the following:
If Tag column contains the words “Day 1” then Actual Start Date column should equal the value of Employment Enablement Date plus the value of Business Day column
If Tag contains “Day 1” and Legal Close column is checked then Actual Start Date should equal Legal Close Date plus Business Day
If Tag does not contain “Day 1” then leave Actual Start Date blank
I've come up with these formulas but cant' figure out how to put them together...
=IF(CONTAINS("Day 1", Tag@row), WORKDAY([Employee Enablement Date]@row, [Business Day]@row), "")
=IF(AND(Tag@row = "Day 1", [Legal Close]@row = 1), WORKDAY([Legal Close Date]@row, [Business Day]@row), "")
=IF(Tag@row =””, “”)
Help Article Resources
Check out the Formula Handbook template!