Formula question

I have two columns, one is 'estimated' age and one is 'exact age'. I want to create a new column 'New Age' where if 'exact age' is populated, it moves that age into the new column and if exact age is NOT populated and 'estimated age' is, it moves 'estimated age' into the New Age column. I hope that makes sense. Thanks in advance!

Common Use Cases

Accepted answers

Emil_Kos

Hi @tpostlewate,

Please try this

IF IsEmpty([exact age]) THEN [estimated age] ELSE [exact age] ENDIF

This formula will show estimated age if exact age will be empty. If exact age will not be empty it will show it as a value.

All comments

Emil_Kos

Hi,

I have prepared a workflow for you:

If this is helpful for you please mark my post as a solution!

If this isn't the exact output please provide us with more details.

New Age.yxmd

AkimasaKajitani

Hi @tpostlewate

You can use Formula tool.

Input :

The expression is the below.

IF IsEmpty([exact age]) THEN [estimated] ELSE [estimated] ENDIF

Output :

Is this helpful?

SampleWF_Formula_AK.yxmd

tpostlewate

Okay, I tried that:
IF IsEmpty([exact age]) THEN [estimated age] ELSE [estimated age] ENDIF

and it filled in 0 if there was an exact age present and a -1 if there was an estimated age (There won't ever be both an exact age and and estimate age, it will always be one or the other), so I did something wrong.

tpostlewate

For some reason, I cannot open the workflows. 😞

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703