I need help figuring out an issue I’m having when filtering a view using a lookup field. I have a project tab and a task tab set up. For the tasks, I have task owners set up.
The tasks work in a chronological order. The first task needs to be complet...
I want to find a way to automatically mark a record as “Used” if it is linked to another table.
Is there a formula for an IF statement for “IF a field has information in it (if it’s NOT empty), add “Used””
Right now I have the following, but I’m rece...
Thank you for the insight! I learned that the [project status] field (my lookup field) is case sensitive so that’s where part of my issue was coming from. The other issue I resolved was adding the task itself to the filters so each conditional group,...
The lookup field I have is not a single select, it’s a text-based formula. However, I’m wondering if there is any way to create a new field based on the text that populates and turn it into a single select? I’m thinking this may help with the filteri...
