Notion Answers

Help between Notion users


Register & Ask

It's free & easy

Get answers

Answers, votes & comments

Vote and select answers

Receive points, vote and give the solution

Question

1vote

Let's say I have a table as shown in the attached image.
https://nebuly.notion.site/Notion-Q-A-6c2a05234c5d40328f9d096e9b0634f3

I would need to save in "Last status update" column when the "Status" cell of the same row was last updated.

This would allow me to write some smart code to prioritize tasks based on days since the last status update (see priority column).

Would it be possible somehow? Thanks in advance

2 Answers

1vote

polle Points77470

It is not possible, "Last edited time" is not cell specific and there is no way to modify that.

On the other hand, you can create a formula based on the Status, so when X status is on that column, then X shows.

I believe the important thing here would be to understand the logic you are trying to create, like the complete scenario to share maybe another option that does the same.

1vote

nadiagiampaolo commented

Hi @polle ! How would I be able to "create a formula based on the Status, so when X status is on that column, then X shows" ?? I'm interested in knowing how this is done.

0vote

polle commented

Sure, please open a new question. :)

0vote

Lizat Points1080

This may also help: You could also use a spreadsheet, I haven't used in anger yet but looks pretty good - Notion2Sheets.

Good Luck

Please log in or register to answer this question.

...

Welcome to Notion Answers, where you can ask questions and receive answers from other members of the community.

Please share to grow the Notion Community!

Connect