-
How to count total number of requests submitted?
Hi, I am trying to find a formula to count the total number of requests submitted in my grid. I want the formula to count the number of request ID's displayed. I want to use this number so I can display a metric on the dashboard. I also want to use a formula to count the number of "In Progress" requests and use this to…
-
Need assistance with Resource Management formulas
I've got a sheet going that lists all of my active projects. Each project has a deadline (in its own "Deadline" column, Archives Department remaining hours (in its own "Archives Hours Remaining" column), Digitization Department's remaining hours (in its own "Digitization Hours Remaining" column), and Platform Department's…
-
Adding a Formula within an "IF" statement
Hey there, I was wondering how I would tell the sheet to read a cell and IF the requirement is met it would generate a value otherwise, run a formula. So something like, IF( "Total Deposit Paid" = 0 than generate "0" otherwise generate "=SUM([Gross Rent]@row - [Rent Credit]@row + [Rent Debit]@row)" Thank you!
-
How to Combine multiple inspection reports into one row
We have a complicated project where we're collecting rooftop inspections with one platform, using Zapier to push it over into a Smartsheet, and from there I need to move these inspections into Salesforce as leads with the Salesforce connector. The problem is, each roof section is coming in as one row. So we will have a…
-
Count of rows created on 2 sheets within a certain time frame.
Hi everyone! I would like to get the count of rows created on 2 sheets within a certain time frame. I created a formula (1) to get the count of one sheet and it worked. I tried to add the other sheet to the formula (2) but I got an error message (3). =COUNTIFS({Created 2}, IFERROR(MONTH(@cell), 0) = 5, {Created 2},…
-
Project Status to Update a Sheet Summary Status - Formula?
Is there a way to have a formula in a row or in the sheet summary that does the following: When a row is added in one sheet and the project status is Completed, then within the project itself in Sheet Summary change the status to Completed as well? I am not sure if it is possible as one status in one sheet would have to…
-
Symbol Formula for values
I need to create Symbol Column Formula to display the following color symbols based on data in another column: Red symbol If value is in Vacation balance column is>= 175 Yellow symbol If value in Vacation balance column is< 175 AND >= 160 Green symbol if value in Vacation balance column is <160 Help?
-
Is there a formula to extract the state from an address?
Hi!! Is there a formula to extract the state from the following address? The state should be after the comma and before the zip code number. 12345 Paris Rd Dallas, Texas 75240 United States Validation Status: Validated 9856 SLEEPING BEAR RD SKOKIE, Illinois 60076-1920 COOK United States Validation Status: Validated 333 E…
-
Text Join Columns with a row range
Hi there- I want to Join collect the Email column(Contact field) and the Palo Alto Additional Emails column(Contact field) together with the ranges of rows 47-49 The first part of my formula worked: =JOIN(COLLECT(Email47:Email49, Email47:Email49, <>""), ", ") But when I added in the second part of the formula it didn't…
-
How can I get a count of new rows created on two sheets?
=COUNTIFS({Created 2}, IFERROR(MONTH(@cell ), 0) = 5, {Created 2}, IFERROR(YEAR(@cell ), 0) = 2024)@cell
