-
Count for number of a specific tag
Hello, I'm new to smartsheet, so please forgive me if this question has been asked. I'm not sure what words to use to search for this type of functionality. I have a smartsheet that tracks award wins and losses. I would like to be able to create a dashboard that tells me how many total wins and losses we have had across…
-
Pie Chart breaks when values are zero
In a dashboard, pie charts are breaks the reference and shows as Unable to display chart when reference values are changed to zero as these vales calculated via formula. Only Bar charts are showing as No data to display. My end goal is to show as No data to display when values are zero. Kindly help me out here.
-
Automation Not Triggering off of a Formula cell
I have two automations that are not functioning. Move a row to another sheet when the status of the row reflects Mastery. Notify someone when a date appears in a cell. Both of the cells that are initiating the triggers are populated from formulas. I'm wondering if this is the issue. Has anyone else run into this problem of…
-
Quick CountIfsquery Please
Hello, Hoping somebody can make my life easier please. I'm currently using the following countifs formula: =COUNTIFS({CoCode}, "114", {Status.}, "Not Started") What can I change it to so I don't have to manually enter a new co. code(eg 114) and status (eg Not Started) every time? Imagine there is some way I can just tell…
-
How do I automatically calculate a due date based on the timeframe a form has been submitted?
Some background: I receive requests for funding through a form that then auto-populates into my sheet. On the first of every month, 3 individuals receive an email notifying them that the applications from the previous month are available for review. The due date to review them is the one week from the day they get the…
-
Help with a formula
Hello All, Getting an unparseable error for this COUNTIFS formula - hoping someone in the community can help me figure out where I am going wrong. Formula: =IF(COUNTIFS({{DC UPS Restudy Status}}, "Restudy Needed", {{Core OpCo}}, "NSP", 1) =0, "", COUNTIFS({{DC UPS Restudy Status}}, "Restudy Needed", {{Core OpCo}}, "NSP",…
-
Email Form
Hello, I am looking to find out if there is a way that a form can be emailed to a teammate who has to fill out at the end of each business day. I have searched the help center but am unable to find an answer. Any help would be greatly appreciated! Thank You!
-
Contacts Display Name vs Email
Hi We have some Contacts who display as their name rather than emails in Contact Columns. This has thrown our Matching and Indexing out from other sheets as the formulas dont pick up Contacts where the Display Name is shown rather than email address's - they just return a #NO MATCH. Is there a way for a formula to…
-
Formula to calculate a total of how in a column year to date
I want to count how many have been hired A220 in the below year to date The formula I used: =COUNTIFS([Date of CJO]:[Date of CJO], @cell <= TODAY(), [Date of CJO]:[Date of CJO], @cell > TODAY(-157), Fleet:Fleet, "A220") and =COUNTIFS([Interview Date]:[Interview Date], @cell <= TODAY(), [Interview Date]:[Interview Date],…
-
How to count how many are in the last 7 days
I am trying to count how many cells are in the last 7 days The formula I used is: =COUNTIF([Avature Application]:[Avature Appication], AND(@cell<= TODAY(), @cell > TODAY(-7)))