-
INDEXM() function to pull nth value from a multiselect dropdown.
After posting a laundry list of what I believe are simple ideas that I thought had already been requested, it was suggested that I post them individually on this idea board. While I think this idea is out there, I am unable to find it. My apologies if this is a repeat: Function to pull Nth value from a multiselect field.…
-
COUNTIFS formula not calculating correctly in 3 of 4 columns- I'm at a loss
What is wrong with my formula? I need it to return the number of times it finds a certain answer from a drop down list for a specific facility between 2 dates. The dates we are searching are from the first of the current month through yesterday. Ex. if it's March 13, 2024, I'm looking for data between March 1, 2024-March…
-
Formula to generate date 1 year from today?
I am trying to figure out a formula that will generate a date that is 1 year from today. For example, if we have a contract that requires 12 months of notice to cancel, and I have a column to track the Earliest Possible Termination Date, I want that column to tell me the date that is 1 year out, or 365 days after today.
-
Symbols for Multiple Columns or Adding Conditional Formating
Hi, Is there a way smartsheet can make it easier to apply conditional fomulas on multiple rows that meet the "N" = red and "Y" = green, rather than having only a format that can let me select multiple columns to the same color when 1 column has a "N" and setting a new rule each time I want to have "N" be red in a different…
-
Symbols on all Columns
Hi everyone, How can I apply symbols to all columns without have to individually right click on column to pick a symbol? Thank you!
-
Need Help with IF and IFERROR
Hello, I have the IF part of the statement working just fine =IF([NEXT Month Quarterly from Today]@row = [NEXT Month Quarterly Due Number]@row, "Yes", "No") - basically it is evaluating if the next month from today is the same month as when the next maintenance is due. In rows where there is not yet data I am getting…
-
Formula help - difference between two form submissions based on a couple of
Hello, I need assistance with creating a formula to calculate the time difference between two submitted forms. One form is submitted when a person checks in, and a second form is submitted when they check out. I'm seeking a formula that considers the date stamps in relation to the Site Address and Check-in Action columns.…
-
Approval flow status - need help
Hello, I am in the process of creating a sheet (two separate forms depending on requesting line of business). My team handles one operation while my peer handles another. I have the automation when forms for specific lines of business it will send our respective teams an update will be sent via email. I also have a hidden…
-
IFERROR, NETWORKDAYS, and MATCH all in one?
Is it possible to have a formula that includes IFERROR, NETWORKDAYS, and MATCH? I'm working with two different sheets, both of which have a start date and an end date column, along with a project ID column. In a third sheet, I need to reference the start and end dates of both sheets using the NETWORKDAYS formula to…
-
Paste Formulas in Reports
We would like the ability to be able to paste formulas in reports and have the formula apply. Example: If I go into a report and paste "=Sum(Children))" then the cell returns this as a literal value of "=Sum(Children))" vs. my goal of having the Smartsheet calculate and display the value of SUM(CHILDREN))