-
Count Project Categories + Count if Before a date
Hi! I want to work out a total number of files we have overdue. I have got as far as adding up all projects that do not include the category completed using: =COUNT([Project Category]:[Project Category]) - COUNTIF([Project Category]:[Project Category], "Complete") I now want it to not include the project category "With…
-
2 sheets for daily production and production schedule for a PO (month) =Status
I have two sheets. One sheet for tracking daily production and another sheet that tracks the production for the month. I have a status column that matches on both sheets. On the production schedule I have that status of the reference number. If production is working on that reference number it has a status of Work in…
-
Help with COUNTIFS function
I am trying to create a COUNTIFS formula to populate a dashboard and can't seem to get it quite right. I am sure it is a very minor issue but was hoping for some help. In the sheet below, I want to create a formula on my data sheet to match the "related product" and the qtr in the "qtr due" column. For example, I want to…
-
CountIF formula between two sheets
Hello, Can someone please point out what's wrong in this formula: =(COUNTIFS({Applied Grants}, "Applied", {submission date}), AND(@cell >= DATE (2025, 1, 1), @cell <= DATE(2025, 12, 31)) I would like to count the total number of grants with the status "Applied" between the Submission date of Jan 1 - Dec 31 2025. Please…
-
PROPER Function
Hi! I wanted to submit a feature request to add to Smartsheet. I organize a lot of documents that are displayed in all caps [Ex. PLEASE SUBMIT ADDITIONAL NEEDED DOCUMENTS]. I have noticed there is not an action/formula available that changes the text to PROPER like in excel [Ex. Please Submit Additional Needed Documents].…
-
How Do I Return a Status/Name From a Different Sheet within a Project in Sheet Summary
Within each project we utilize Sheet Summary to pull into reporting and ultimately dashboards. There are a couple fields that I would like not to be manual, but instead use some kind of formula if I can. The issue is that the formula would have to pull the name/status from a different sheet (I noticed there is a reference…
-
Add months to a date
Hi Team, I need to create a formula to add X months to a date (X) to calculate a due date. Any suggestions? Thanks in advance!
-
Fomulas and automation
Hi Everyone. I have a rag status column on my Smartsheet which is determined by a formula, so as the task becomes due or overdue the rag status updates from green→amber→red. I'd like to receive a notification as tasks transition to amber/red. I created an automation, based on the change of rag status, but it only triggers…
-
COUNT IF Certain Project Category, resource and in Current Month
Hi! I am trying to create a sheet summary formula for each team member which shows the total files they have with a consultant in the current month. We generate a new sheet each month so i only need it to count after 1st of the month. I can't even get just a basic number of all projects with consultant after the 1st of the…
-
Dashboard Help- Widgets and COUNTIFS
I am new to Smartsheet and making a dashboard. I want a widget to show as a pie chart illustrating how many : 1. "SRM"(child rows w/ purple check marked and bold text) there are [see screenshot below] 2. if it is "closed"(box checked) or not. I know I need to make a separate metric sheet with a COUNTIFS formula referencing…