column date depending on symbol column

Options

Hey,

I couldnt find an answer to my question here, therefore I hope you can help

I have columns:

1) star symbols

2) last date ( I enter manually)

I want to calculate "next date" f.e.

if star is "1" or "2" = last date + 90 days

if star is "3" or "4" = last date + 60 days

if star is "5" = last date + 30 days

if star is "6" = last date + 14 days

do you have an idea to solve :-)

Thank you

Tags:

Options

I have found the solution myself right now:

Since everything is located to Germany the formula has to be adapted in all parts -

=IF(OR([Relevanz für Kunde]@row = "null" => "null" instead of the english "zero" and so on.

Now, it works. Thanks for helping

Joerg

• ✭✭✭✭✭
edited 07/28/22
Options

I noticed the star type symbol ranges from Empty to Five. Not Six

So here is a formula that drops the "if star is "6" = last date + 14 days"

=IF(OR(Star@row = "One", Star@row = "Two"), [Last date]@row + 90, IF(OR(Star@row = "Three", Star@row = "Four"), [Last date]@row + 60, IF(Star@row = "Five", [Last date]@row + 30, IF(Star@row = "Six", [Last date]@row + 14))))

• Options

Hi Dan,

I put following line and get a blank cell:

=IF(OR([Relevanz für Kunde]@row = "one"; [Relevanz für Kunde]@row = "two"); [letzte Aktion] + 60)

Columns [Relevanz für Kunde] and [letzte Aktion] are date columns

Any idea ?? :-)

• ✭✭✭✭✭
edited 07/28/22
Options

=IF(OR([Relevanz für Kunde]@row = "one", [Relevanz für Kunde]@row = "two"), [letzte Aktion]@row + 60

Sie hatten ; anstelle von , und benötigte @row am Ende der letzten Aktion

wenn kein Datum vorhanden ist, bleibt es leer

• Options

=IF(OR([Relevanz für Kunde]@row = "zero"; [Relevanz für Kunde]@row = "one"); [letzte Aktion]@row + 30)

in Germany it is automatically ; instead of ,

and I put @ at the end but result is still a blank cell

I am sorry to bother you again but hope you have another idea?

KR Joerg 😪😁

• ✭✭✭✭✭
Options

Is there a date in the letzte Aktion cell? If there is not it will be blank.

• Options

yes, it ist. Still blank.

both columns are date columns. But I tried to change from date column to text column as well for [nächste Aktion] -

with the same result.

Options

I have found the solution myself right now:

Since everything is located to Germany the formula has to be adapted in all parts -

=IF(OR([Relevanz für Kunde]@row = "null" => "null" instead of the english "zero" and so on.

Now, it works. Thanks for helping

Joerg

• ✭✭✭✭✭
Options

Excellent! glad I could help.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!