Auto add solved date on list with IF function, equal to other column's value

%3CLINGO-SUB%20id%3D%22lingo-sub-3275453%22%20slang%3D%22en-US%22%3EAuto%20add%20solved%20date%20on%20list%20with%20IF%20function%2C%20equal%20to%20other%20column's%20value%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3275453%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Guys!%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20struggling%20with%20the%20following%2C%20I%20have%20a%20%22solved%20date%22%20column%2C%20where%20I'd%20like%20to%20add%20the%20solved%20automatically%2C%20if%20status%20equals%20to%20Closed%20status%20then%20it%20should%20be%20the%20last%20modified%20date%20(it's%20another%20columns%20value)%2C%20for%20anything%20other%20status%20should%20be%20today's%20date.%20I%20modeled%20the%20logic%20in%20excel%2C%20it%20works%20there%2C%20but%20when%20I%20translate%20to%20Sharepoint%20it%20says%20error%2C%20I%20just%20can't%20figure%20out%20why%20it%20is%20not%20working.%20Does%20anyone%20has%20any%20idea%3F%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20come%20to%20this%20formula%3A%26nbsp%3B%3DIF(%5BStatus%5D%3D%2210.%20Closed%22%3B%5BModified%5D%3BIF(%5BStatus%5D%3D%2212.%20Closed%22%3B%5BModified%5D%3BTODAY()))%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks!!!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3275453%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3Eif%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3Elist%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ELists%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3275517%22%20slang%3D%22en-US%22%3ERe%3A%20Auto%20add%20solved%20date%20on%20list%20with%20IF%20function%2C%20equal%20to%20other%20column's%20value%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3275517%22%20slang%3D%22en-US%22%3EHi%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F174092%22%20target%3D%22_blank%22%3E%40RobElliott%3C%2FA%3E%20yes%2C%20I%20am%20definitely%20interested%2C%20could%20you%20post%20the%20steps%3F%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3275482%22%20slang%3D%22en-US%22%3ERe%3A%20Auto%20add%20solved%20date%20on%20list%20with%20IF%20function%2C%20equal%20to%20other%20column's%20value%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3275482%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1352688%22%20target%3D%22_blank%22%3E%40Eszter_003%3C%2FA%3E%26nbsp%3Byou%20can't%20use%20Today()%20in%20a%20calculated%20column%20which%20is%20why%20you%20get%20the%20error.%20So%20you'll%20need%20to%20think%20of%20another%20way%20to%20achieve%20this.%20A%20simple%20flow%20in%20Power%20Automate%20could%20do%20update%20the%20list%20whenever%20the%26nbsp%3B%20status%20column%20(in%20my%20case%20Status3)%20is%20changed.%20If%20this%20is%20of%20interest%20I'll%20post%20up%20the%20steps%20asap.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERob%3CBR%20%2F%3ELos%20Gallardos%3CBR%20%2F%3E%3CFONT%20size%3D%222%22%20color%3D%22%23006400%22%3EMicrosoft%20Power%20Automate%20Community%20Super%20User%3C%2FFONT%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Hi Guys! 

 

I am struggling with the following, I have a "solved date" column, where I'd like to add the solved automatically, if status equals to Closed status then it should be the last modified date (it's another columns value), for anything other status should be today's date. I modeled the logic in excel, it works there, but when I translate to Sharepoint it says error, I just can't figure out why it is not working. Does anyone has any idea? 

 

I have come to this formula: =IF([Status]="10. Closed";[Modified];IF([Status]="12. Closed";[Modified];TODAY()))

 

Thanks!!!

2 Replies

@Eszter_003 you can't use Today() in a calculated column which is why you get the error. So you'll need to think of another way to achieve this. A simple flow in Power Automate could do update the list whenever the  status column (in my case Status3) is changed. If this is of interest I'll post up the steps asap.

 

Rob
Los Gallardos
Microsoft Power Automate Community Super User

Hi @RobElliott yes, I am definitely interested, could you post the steps?