-
Count if Expiration Date is in the next 3, 14, 30 Days without counting Past Expiration Dates
My Formula is "=COUNTIF({Expiration Date}, <TODAY(3))" switching out the number for the appropriate timeframe. When I do a filter on the sheet it is referencing to there is only 1 expiring in the next 3 days however the formula keeps giving me an answer of 2. I am unsure if it is counting the 2 that are past the expiration…
-
Hello!
I'm relatively new to using Smartsheet, and I have a question regarding a formula I'm trying to create. My colleagues and I are tracking our steps for a work event, and I've set up a sheet and a form for them to submit their work email addresses, dates, and total steps. What I want to achieve is a formula that can…
-
tracking # of employees quarter over quarter
I'm trying to show on a graph how many employees we had in each quarter. How would I do that? My initial idea is to add a helper column for each quarter, and add a formula to return a 1 if any of the date range of that quarter falls after their start date and before their end date, then pull a report counting the 1s for…
-
How to update a column formula for new ID prefixes
Hi everyone, I am not sure if I am going to explain this correct, but here it goes: Last year, with the help of engineers at Smartsheet, I had built a project management suite for one of my agency divisions. We have everything from dashboards, to meta data and archive sheets. I wanted to replicate this management suite to…
-
How do I count the reason for the consult, AND the year it took place?
I tried to amend this formula to report by year. Below is the formula I tried, which didn't work. The reasons are part of a drop down on another sheet. The consult date is on the same sheet, but the full date is in the cell, 10/12/2017, 11/1/2017, etc. My current formula in the TOTALS to DATE is: =COUNTIF({Reason for…
-
Multi-Selects and COUNTIFS
Hello, I have a column with multi-selections. Can you help me with a formula that will count the number of selections and display the symbol "Half" when there are more than one selection counted? Thanks, Amy
-
Matching Company Name Based on Member Name Chosen
Hi There! We have sheets called Meeting Trackers that we log the name, company name, and company category of the attendees of each workgroup meeting. We have 30+ meeting trackers that we've maintain between 5 meeting facilitators. Through Power BI we collect all the Meeting Tracker information and it should give us what…
-
Needing a formula that shows how many requests get entered each month
I am building a ticketing system and need to identify how many specific requests get entered each month by a specific department. It would need to use the Request Type "Template Request", the Division "Primary Care Lebanon" and the Request Entered Date.
-
All Project Presentation - Visual Aid
Looking for input or suggestions. Is there any software that can gives us a nice presentation of all projects to show management? For example, projects for the entire year that show start and end dates . Example below:
-
Column Value to Multiselect
Hello - I'm using a multiselect formula but it's populating a "0" in front of the multiselect if the multiselect is zero or one value. My formula: =IF(CONTAINS("Yes", [Air Travel]@row), "Air/Flight" + CHAR(10)) + IF(CONTAINS("Yes", [Rental Car]@row), "Car" + CHAR(10)) + IF(CONTAINS("Yes", Hotel@row), "Hotel" + CHAR(10))…