-
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…
-
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…
-
Generate a date 48 months from "Delivered Date" and at the End of Month
I am tracking vehicle leases for our company and I would like to have an "Expiration Date" auto generate 48 months later. The kicker is our leases always end at the end of the month so is there a formula that can generate that for me? I have been able to get the 48 months generated but there is not an EOMONTH function…
-
IF / OR formula then Check a Box
I need a formula that IF a specific column has either 1 of 2 specific choices, then a BOX in another column is checked: =IF(([Study Status]@row = "Active/ Open to Accrual", 1) OR([Study Status]@row = "In Start-Up", 1))
-
Unique codes
Hey all, I am trying to create a system that will check a unique code that is entered through a form and display if this code has been used already or not. I have a formula in the summary sheet that will asses if the code has been used or not: =VLOOKUP($Code$1, {Z Codes Trial Database Range 1}, 3, 0) The problem is that I…
-
Formula - convert a name to e-mail address
Hi all, I am looking to convert a name to a e-mail address using a formula. This is the example: convert 'Andreas Johnson' to 'Andreas.Johnson@company.net'
-
% Complete Formatting in JOIN Formula
I am trying to Join various data points into one cell and when I join the % complete, it changes to decimal format. I've tried adding Value in from of the %complete, but get the same result. Can someone let me know if there is something I should add to my join formula to convert the decimal to percentage? Thank you Tiffany
