-
Issue with transcribing a reference formula for Add-On Rates
Hi, I'm having an issue with writing a reference formula for Add-On Rates. I've included pictures of the Reference Sheet and the Main Project Tracker here, with Client Name info redacted. The "Team Member Rate Sheet Pull" helper and "Project Rate Sheet Pull" helper columns both have formulas that work: Team Member:…
-
Formula question
I am writing a formula to figure the duration of a status. I have a Status dropdown column, Date Column (captures date the status changes) and a Duration column that calculates "today - date column" for the duration. Now though, when I change the status, it triggers the next status to start the cycle, but it keeps…
-
ENCODEURL Smartsheet Function
We have several use cases where we build custom URLs that include column data from a source sheet into a Smartsheet form URL string on a target sheet that hosts the form. It would be very helpful if Smartsheet had a function like ENCODEURL. Currently we have to build an ugly formula with multiple embedded SUBSTITUTE…
-
Count Multiple Values in the Same Column
I'm trying to write a Sheet Summary formula that will tell me how many times multiple criteria appears in one column based on the conditions of another column. I'm struggling with the OR function, and all my COUNTIFS formulas result in 0. I'm using a simple table to help me learn how to write Sheet Summary formulas, but my…
-
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…
