-
Nested If statements
I am new here, but cannot figure out how to make a nested if statement or an automation to change the status based on a date in the past. What I would like to happen is when any of these dates are in the past AND the check box is not checked the current status will change to "DELAYED". I can get it to work for one argument…
-
Capacity Planning Formula
Hello! I'm looking for a way to track the amount of hours assigned to a person by week and by month. I’ve gotten a formula to count total hours for a specific person, but I’m stuck on how to get to the next level with supporting my team with capacity planning. Hoping for a different/beefier formula or a way to build on…
-
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…