Connect with peers, share your expertise, and inspire what’s next in Smartsheet — from proven practices to practical how-to insights from fellow users and product experts.
Sign in to join the conversation:
Hi,
I am trying to count live tasks that are overdue but I am getting #INVALID DATA TYPE
This is the formula I am using
=COUNTIFS(Status:Status, <>"Complete", [End to End Due Date]:[End to End Due Date], <=TODAY())
Any ideas?
Thanks
Karen
Hi Karen,
At a glance, it looks correct. Did you write the formula in Smartsheet?
Hope that helps!
Have a fantastic day!
Best,
Andrée Starå
Workflow Consultant / CEO @ WORK BOLD
I have just started using Summary Sheet. It's the only formula I have had problems with so far. I have tried it on other sheets as well with no joy.
Sorry, wrong screenshot
Do you have any blanks or "non-dates" in your date range?
Perfect! There were non-dates! Thank you so much
Happy to help. You can have non-dates within your range. It just requires some slight tweaking in our formula to account for.
Happy to help!
I saw that Paul answered already!
Let me know if I can help with anything else!
Andrée
Hi Paul,
Sorry, another quick question. I do have some date fields in another sheet that do need to be blank. How do I change to ignore them?
=COUNTIFS(Status:Status, "Live", [End to End Due Date]:[End to End Due Date], IFERROR(DATEONLY(@cell), TODAY(1)) <= TODAY())
Give this a try and let me know how it works out for you.
Hi all! I'm working on a column formula that will check whether the Column2ref cell in the current row is blank. If it is blank, the formula finds the maximum value in the ID column where the Trainer Name matches the Trainer Name cell value in the current row and the ID cell value is less than the ID cell value in the…
How do I see who submitted a form for a specific sheet?
Hi, I have a Gantt covering 500+ rows of events past and planned. I use it to predict and track values around these events. Using helper columns to identify the current week, I get an email report on a Monday that tells me the upcoming events in the current week (7 days) and their values. Currently if an event spans…
