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 anno…
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 ea…
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…
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…
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]…
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 …
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 r…
I have multiple forms that can be used to submit data to a worksheet, and I'm wondering if there is a FORM ID that could be used in a column so I know which form was submitted. If yes, is there a spec…
Hello, I'm encountering an issue with the INDEX/MATCH function. When the value in the cell being match does not find a match and is recognized as text rather than a number, the formula does not return…
I am using the collect function to pull a start date from a project sheet (which has project setting enabled) with two criterias. first criteria is to reference a task name and second criteria is pull…
