-
Countifs not working properly
Hi Everyone, I'm looking to pull any trainings that were "Direct" from the Past 30 Days. Anytime I enter the formula it says #Unparseable. I'm not sure where I'm going wrong. =COUNTIFS({Training Type Column}, "Direct", {Date Entered Column}, ">=" & TODAY() - 30)
-
TIP: How to reference a \ backslash or " double quotes in formulas + [ ] in Col Names
While researching a problem I had and the absolutely simple solution that was causing it, I decided I would write this post to help people in the future. This is not an official post, just me trying to give back to the community in hopes it helps someone, so if you have more info to add (or correct me) please post it…
-
IF and BLANK nesting formulas
I am trying to use an IF statement in the approved column that says "If status is requested, return PIPELINE, all other statuses return APPROVE, unless it's blank then leave the cell blank". Everything I try returns #UNPARSEABLE. I had it working but someone messed with my sheet and now I can't get it back! Help :)
-
Feature: Enable Conditional Responses to Different Formula Errors in Smartsheet
I would love to be able to take action within a formula based upon which specific error the formula spits out. Right now, the IFERROR function catches errors but doesn't tell us what kind of error it is. It would be great if we could recognize different errors like #BLOCKED, #UNPARSEABLE, #DIVIDE BY ZERO, and others.…