Hello,
I'd like to count the number of days from created date to today only if the status of a ticket is "Open". If it's "Closed" I'd like it blank, I'm not sure how to do this.
Here is an image of the ideal results
Thanks!
Try this:
=IF([Status]@row = "Open", TODAY() - [Created Date]@row, "")
Perfect! That works. Thank you so much Nic!
I have a Sheet with multiple columns the values that make up these columns are derived from a count formula. I cannot figure out how to generate a report that allows me to exclude only the columns that have zero values. I am trying to filter the report in a way that only the columns (which are categories) that are greater…
I ask this question because i have switched my grid sheets before to table view and exited out of the sheet, then when i come back its back in grid view. Just wondering if thats normal. thanks
Hi there! I'm hoping this group can help. I'm building out program/project management & tracking at my company. We have 8 grids (one for each dept) that funnel into multiple reports and dashboards. Within each grid/sheet, there are multiple projects that have CHILDREN project plans nested underneath. We want project owners…
