Comments
-
Wow - i think that worked, i need to test this out a bit more, but its looking good. I was way off on my first attempt haha thank you for clarifying @rco. I wish I understood better what exactly is happening here, but I'll figure that out. I'll keep validating this, but I think its working!
-
@rco - Hey, i really appreciate you taking the time to respond. I feel like i followed your instruction correctly, but not sure the result is correct. Take a look at my screenshot above and please let me know what you think. Its very possible i did it wrong haha To clarify, the goal is to have one row per transaction, and…
-
@ArborRose - that seems to work! thank you! so you believe that as the week moves on, and the dates change, that formula will continue to return 9/16 until monday next week?
-
Hey @Manasi_Panov & @ArborRose - so yesterday (on a monday) the formula was returning 9/16, which was the date on monday of last week, which is exactly what i needed. But now, on a tuesday, the formula is returning 9/23 (the day of monday this week, which i guess is the most recent previous monday?). But i need this…
-
This worked great, thank you so much!
-
Hey @ArborRose - that worked! It seems to be returning the date of monday of last week, thank you! The issue now is I need to include this number in the card title or the summary number of the card - but this beast mode does not show up as an option. Would you (or anyone) have insight as to how to change that and make it…
