-
Counting values within multi selection dropdown column
I used a multi selection dropdown column to select each company that sent in a bid for that project and I want to keep track of the total number of bids sent for each company. The formula I used is COUNTIF({Architect Selection}, "BSA") to count the number of times BSA appears in the column I referenced from another sheet.…
-
How can I get rid of rows that are not applicable?
I am creating a report with any upcoming tasks that are due within the next 14 days. However, when I do that, it pulls in my entire sheet, even rows that are in the future and not within the next 14 days. How can I get this to only show tasks that are due within the next 14 days?
-
Multiple Criterion with Cross Sheets
Hello I am stumped. I have tried several different combinations to my formulas trying to get them to function. I get an #UNPARSEABLE error most of the time. I have tried this formula =COUNTIFS({Complete Claim Status}, Status@row, {Vendor Name}, [Vendor Name]@row) Complete Claim Status is the range on my cross sheet |…
-
Using RIGHT/LEFT or FIND/REPLACE?
I thought that by using RIGHT and returning the values after ", " that it would fix the issue I'm having but depending on the difference in timestamps, I may get 7 or 8 characters so this formula doesn't work out for me. Would using FIND/REPLACE work, such as finding ", " within the column and replacing that with just ""…
-
Formula to pull in fiscal work week is incorrect
I am continually getting the incorrect work week. In the below screen shot the Onboarded Week should be Week 16. Attached is our lookup sheet from smartsheet. Our fiscal week starts on Saturday, January 29, 2022 and the fiscal week ends on Friday, February 4, 2022. the pattern is 4,4,5 (kinda) you can see it gets a little…
-
SUMIFS with date ranges
Hello, I'm trying to sum the values (Annual Billing Amount) for anything that falls between 2/22/22 and today but I can't get my formula to work. Not sure what I'm doing incorrectly. =SUMIFS({Annual Billing Amount}:{Annual Billing Amount}, {Date to Deactivate}:{Date to Deactivate}, AND(>=DATE(2022, 2, 22), <=TODAY()))
-
Can you please add a find and replace feature that can edit formulas within the selected cells?
This would be a huge time saver! Similar to what is explained here (Find and Replace Values Within a Sheet | Smartsheet Learning Center), but adding the ability for it to adjust formulas.
-
SUM IF with OR and CHILDREN
Hello, I am trying to add one additional condition to this statement below, but can't seem to figure it out. Here's what I have currently (which works): =IF($[Row Identifier - Budget]@row = "Parent", SUMIF(CHILDREN([Alt Cost Center]@row), "", CHILDREN()), "") And I'd like to add an additional option that says if [Alt…
-
Another formula question
Please could someone help to show me where I have gone wrong? I have been through this many times and cannot see why I am returning "Incorrect Argument Set". =IF(AND([Column Name]@row = "Link Active & Works", [Column Name]@row = "Link Active & Works", [Column Name]@row = "Link Active & Works", [Column Name]@row = "Link…
-
How to track burn rate
I am trying to write a formula for burn rate in smartsheet. (Summary11 - Summary14) / (TODAY() - [Delivery Date]19). I want this formula to extend to [Delivery Date]514 as the data is being entered each day. When I use [Delivery Date]514 in the formula I get # DIVIDED BY ZERO error message. When I include the IFERROR in…
