Hello! Noobie here trying to get a bit of help creating a formula. The goal is to get some visibility on when I last commented on a record vs when someone else last commented. This will help me see if they have replied or not so I know to follow up.
...
Hello! I have two tables: “Projects” and “Tasks”. I’m wanting to create an automation to do the following:
Trigger: When a record is created in “Projects” table
Action: Create value {Record Name} in X field in “Tasks” table
Basically, the name of the...
Hi everyone! I’ve created a base with two tables:
ProjectsTasks
There is a link between both tables so that tasks can be related to projects.
What I’m trying to achieve is something like this:
The goal is to visualize all projects to see what tasks ...
Hello!
I’m looking to create a calculated field that shows me the number of days it takes to complete a record. The start date should be when the record is created, and the end date will be based on a dropdown field’s value (e.g. when the status fiel...
Thanks @Elias_Gomez_Sainz ! Tried to figure it out by myself and I think I’m close? I’m trying to basically say:
If {last commented by me} is blank, OR if {last commented by someone else} is after {last commented by me}, then calculate the time diffe...
Hi @Elias_Gomez_Sainz ! Thanks so much for your reply. Sorry, I’m new to formulas so I’m a bit lost. I sort of understand where you’re going, but not really sure how to implement it. Are you able to share an example of what the formula you’re propos...
Oh cool, yeah that would be ideal because I’m not able to add tasks from the grid task view. However, I’m not able to connect the filter to the tasks element :confused:
