Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
How do i create new field which is calculated such that it gives a new value as compared to the existing field,
the calculated field consist of values such as submitted, approved etc.
so if the submission date(a field) has passed today's date then it will give an output 'submitted'.
If([Submission Date]>Today(),'Submitted',if(Something=SomethingElse,'Approved','SomeOtherOption')
You can nest as many if() statements as required.
hi, thank you for your help! i tried this with '-' as my else output :
If ([official approval date] < Today(), 'Approved' ,if [registration expiry date] < Today(), 'Expired' ,if [official submission date] < Today(), 'Submitted' ,if [internal dispatch date] < Today(), 'Dispatched'
,[ '-'] )
but couldnt proceed as there was an error, do u mind helping to check?
All of your inner If statements are missing their opening and closing parenthesis. It should be If(Condition,Then,Else)