-
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:…
-
Pull latest amount from a column based on date column
I have a sheet that my Finance team updates every week with an update request and would like to pull the latest update amounts for the different bank accounts into an overview sheet for the executive team. For example, in the screenshot below, I want to pull the 2/24/25 update for the Operating Account, 2/10/25 update for…
-
Trouble with IF statement and date format conversion
Hi all, I'm having a formula issue that I need human support for. [AI is failing to translate it properly]. Here's my scenario (I'm so close!): I have an orange text column [Delayed Result Date] that sometimes contains MM/YYYY format and other times MM/DD/YYYY format. I need to make it a (yellow) date column [Delayed…
-
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…
-
Maximum Concurrent Tasks
Working with a multi-family developer building multiple apartment buildings on the same project. Trying to get in front of bottlenecks in the schedule where we're expecting multiple crews in multiple buildings and end up short staffing or over staffing. For instance, Row 58 the Framer should be starting Task "Wall Framing"…
-
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…
