- Need to return the first NON-BLANK value if [Client full name]@row matches {Client full name}
I have a MASTER sheet containing client data, and an UPDATE sheet to use for processing updates to client data (i.e. users submit data updates via a form and the latest entries go to the top of the sheet). To ensure my master sheet contains the most up-to-date client data, I am trying to use an INDEX/COLLECT function to…
- 我有困难使用”和“,”或“&"Countif(s)" to build a formula.
Hello, I am attempting to come up with a sheet summary formula that counts cells if they meet at least one of 3 different statuses in the same column, AND also meet one of 5 different statuses in a separate column. So using the screenshot I've provided as an example (although it doesn't have 5 different statuses in the…
- Help with date calculation formula
Hello, I'm trying to find a formula that will help me calculate how long an intake took to resolve. The rows I need to be calculated are Date Reported & Resolution Date. If the resolution date is blank I want it to use the current date in the calculation to see how long this issue has gone unresolved. Any help is much…
- Pull multiple IF THEN statements from data sheet?
I have a data sheet with 4 Columns that I'd like to pull into a second. In this simplified example, the Data sheet shows phase, activities which repeat for each phase and a date. I also have a column with "Yes/No" if I need the date in the Smartsheet. What formula do I use to get the data to my second layout? I'd like it…
- Add Months to Date formula?
I've read through a lot of the help topics and others' questions, but haven't been able to find a simple solution to my issue - which I think is fairly simple. I'm trying to add a certain number (Varying) of months to a start date to produce an end date. I have a start date column (which is a date column), a column that…
- Using IF/OR statement in a formula
Hi, I'm trying to have the status on Row 9 update to 'Complete' if either Row 10 or 11 have a status of 'Call - Scheduled' but I am getting an error. =IF(OR([Status10]="Call - Scheduled", [Status11]="Call - Scheduled"), "Complete") Thanks!
- JOIN() Formula Result - Producing Apostrophe in Copied Cell Data
The issue involves the usage of the JOIN() formula within SmartSheet, which is resulting in the inclusion of an unwanted apostrophe when the formula's output is copied to another sheet. The JOIN() function is designed to concatenate values, but in this scenario, the copied data is displaying an apostrophe that is not…
- Combining Not Contains and Contains into the same formula
hi Team, The below formula. I am trying to combine these validations into one statement. If any of them are true, the row should flag as yellow. If any of them are false, it should flag as green. However, the statement is flagging as "green" when "warning records" is not found. It should flag as yellow.…
- Searching with INDEX(MATCH(
Hello, I am working on building a portfolio level sheet that can operate as a searching tool within Smarthsheets and I'm looking for a little assistance to create a method to find based on key words rather than exact matches. Is this possible? What would the returns look like if there were multiple values? Also the below…
- Other than Sheet Activity Log and cell activity, can I tell what something has been changed from?
I have a Smartsheet where there are dates I have put in and I want to see what it's changed from after I've made a change. I know I can look at the sheet activity or look at individual cell activity, however, I want to see those dates side by side. I need to be able to show what I have scheduled for something and then what…
