-
CountIfs Formula between two criteria
I am trying to do a formula that will pick up the tester and also if it is between a set of range of dates. I did one formula picking up the name, and one doing the set of dates. When I combine the two, I am not able to get it to work. Could someone tell me what I am doing wrong. I am hoping this formula will show the…
-
How to add multiple costs from dropdown menu items
Hello, I am struggling to identify a formula that can read multiple selections in a drop down column, find the corresponding selections and prices on another sheet, and return a total cost. The sheet supports samples that are analytically tested. The user chooses which tests they want to conduct for each sample on the…
-
Check a box if date is in the past or in the 60 days
Hello! I have this formula that will check the box if the date in a second column is in the past. Is there a way to include if the date is 60 days in the future? Check the box if the date in Column 2 is either (1) in the past or (2) 60 days in the future. IF([GWO - BST (2yr)]@row < TODAY(), 1, 0) Thank you in advance!
-
How to extract time from Date created auto column?
Hi all, I want to extract only time from Date created auto column (in format HH:mm:ss) I've tried VALUE(RIGHT(Created@row, 8)), but it seems i can only take two first numbers and ":" is blocking the formula, and i get unparsable if i go any higher than VALUE(RIGHT(Created@row, 2)). What would be the correct approach to…
-
Keeping attachments with Index row value
I have a sheet where I query 14 other sheets to collect all sorts of data (unique values from sheet into a column) and in another column I use an Index distinct collect to get all the unique value from those 14 columns, this is the 'Index' column. At some point a user will want to generate a certificate associted with the…
-
COUNTIF formula not counting correctly
Need some help with a formula that doesn't seem to be working. For context, here is a description of the sheet setup and formulas I'm using (+ I've attached an image with screenshots of all the pieces as a visual aid). The sheet I'm working on is our RAID log template that we have built into our control center solution. We…
-
Move Row Action - getting moved rows to the top of the sheet.
I'm using the move row action to automate archiving. The flow works fine, however when the rows get added to the new sheet, the are added to the same row number e.g. row 100. So my archive sheet now has 99 blank rows before the archived items are added. Is there a way to fix this? Screen shot of my automation below. I also…
-
Time Elapsed to Today in Months/Years
Hi! I'm trying to figure out how to use the NETDAYS formula to show how long someone has been a member of a certain team. I can't get it to measure to today using the formula that the website suggests. I want it to be running so that whenever I log on I can see the time elapsed to the day I'm looking at the sheet. Can…
-
How to trigger an action from one Smartsheet to another
I'm working on 2 Smartsheets right now and am trying to create a formula between the two. My first Smartsheet document is called "Stores in Progress." The 2nd Smartsheet is called "Ready for Service." In my "Stores in Progress" Smartsheet, I have a checkbox column called "Ready for Production." I want to design it so that…
-
Conditional Formatting Not Working
I have a conditional formatting rule that says when [H-Public View Enrollment (Go-Live Date, Check)] is checked, change formatting of [Public View Enrollment (Go-Live Date)] to red background, white text. The rows in which this is true do, in fact, change their formatting. But, all of the other rows that don't meet this…