-
Formula Help
Hi - I need help with a formula for a sheet summary field. 1. Open Tasks that are due in the next week. I want to capture a status that does not contain "Complete" and then if the task is within the next 7 days. 2. I also want to capture the count of open tasks that are overdue - i.e., in the past. Thank you!
-
Using =Value to return a number but gettting error
I have the following cells that I need to use in an Index(match I cannot control the format, and ideally would like to resist using a helper column. The numbers vary in length and the blank spaces, "-" and leading zeros become an issue with Index(match. The formula I am working with to adjust and want to use for the Match…
-
Joining text "if" a criteria is met in multiple rows / columns
Hi, I'm trying to do something a bit complicated and hoping for some assistance. I am trying to join text from specific columns IF another column has specific verbiage in it (Campaign 1). Below is an image of the rows and the column with that verbiage. Do you know what would be the appropriate formula for this? I want to…
-
Working with Symbol Formulas
Hello Smartsheet Community! As our Community grows, I am starting to see some trends about features and workarounds users want to learn more about. For these topics, I am starting a new series of announcements. In this series, I will write about trending topics and topics that you request! After I post about a subject, I…
-
Salesforce Connector
Good evening - We use the Salesforce Connector to sync account information to Smartsheet. Syncing all accounts to a single Smartsheet exceeded cell limits. So, we created a different Smartsheet for each account status (i.e. Client, Former Client, Vendor, etc.). I hoped to create an automation that would remove the…
-
Copy to other Smartsheet when row is added or UPDATED
I have two sheets, lets say A & B, which are currently blank and will be used to gather patient information. I'm trying to copy anything entered in sheet A to sheet B including if an updates have been made (e.g. if a name is entered incorrectly in sheet A and later corrected, sheet B will be updated in the same row and not…
-
RANKEQ with multiple filtering criteria
I have been trying to rank my rows that are listed as "Tier 1" in the {Level} column in order of importance based on the following criteria: 1) Highest Rank: Rows with the oldest {R/O Create Date} AND BOTH {OOS} and {Warranty} columns are checked. 2) Second: Again, oldest R/O create date, with the {Warranty} column…
-
Can I use Summary fields in formula
I have created some sheet summary fields to count the number of records that meet a specific criteria e.g. Fire Doors - Pass is the summary field and the formula is =COUNTIFS([Last Month]:[Last Month], ="True", [Fire Doors]:[Fire Doors], ="Yes") I have done the same for several other fields too e.g. Fire Exit Routes -…
-
Replicating a Excel formula in Smartsheet
I am trying to replicate a formula in Smartsheet from an Excel formula. However, Smartsheet is returning an #INVALID REF error. I have attached a picture of the formula in both formulas. ANy guidance would be appreciated. EXCEL…
-
Budget Rollup based on used Resources
I currently have this formula for my budget =IF([Resource Helper column]@row > 4, [Quoted labor budget ]@row - (200 * ([Resource Helper column]@row - 4)), [Quoted labor budget ]@row). I want to do a roll up each time an additional resource is added in the child rows and any additional rows for created for each project. Im…