Forum Discussion

ben-t's avatar
ben-t
Frequent Visitor
5 years ago

how to leave existing data after IF ELSE function

I'm extracting data off a sharepoint list where the status change of each issue is updated as the issues are fixed. 

I'm trying to keep a daily record of the count of each status,

Is there a way for it to count IF the date is today, ELSE leave the existing data? 

thanks

 

Need Help
Tutorial Requests

2 Replies

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    5 years ago

    ben-t , What column you want leave put that in else

     

    example 

    if([Date] = today() , counrows(filter(<Your code>)), [Column 1])

     

    • ben-t's avatar
      ben-t
      Frequent Visitor
      5 years ago

      I want to keep the data in the same column that was written the day before. 

      the code that i've written only writes to today's date, then for every other date it wipes the values. 

      i tried selecting the same [completed] column in else, but there seems to be an error. 

       

      If not, is it possible to write this row of data to a new sharepoint list?