-
Column formulas
Can I exclude one cell from a column formula?
-
Formula to return any text found in range of cells?
I'm looking for a formula to return the exact text in a range of cells. Each row will only have one cell that will have text in it. I don't want to know True/False if there is text, but rather what the exact text is. The fields are drop-downs connected to a form.
-
Best practice question for dashboards and performance
I am in the process of changing everything over to Smartsheet from another package, and am having a great experience so far. I did have a question for experienced users that has to do with best practices when displaying information on a dashboard though: Is it better to have a helper sheet, or use the Sheet Summary for…
-
Partial text search
Hi All! I'm looking for a formula that does a partial text search, counting shift codes containing "AS." The column will appear as below, but I want the formula to only consider the AS. It will need to be added to the formula below, =COUNTIFS({USER ID}, [Team/ Colleague ID's]@row, {Period2}, [Period ]@row, {year2},…
-
Record a Date Automation not working with Move sheet automation
I have a checkbox that triggers two separate automation. Box checked = Record date Box checked = Move row to another sheet. The move row automation is working, but the record date is not. Any ideas?
-
30 days past due warning
Hi, I need to find automation or formula but not sure which. I have a column of due dates, I need a another column to say "30 days" if due date column is over 30 days past due. Any help is appreciated. Thank you Kim
-
Linking Smartsheets to Excel
Is there a way to link Smartsheets to Excel. I have a sheet in Smartsheets that I need to populate with the current months actuals each month. The actual data for the month is summarized in the same file each month. Instead of keying in the data each month or trying to copy the data I was hoping that I could establish a…
-
INDEX/MATCH to fix #NO MATCH Errors, when row does not exist
Okay, first, thanks so much for reviewing my question, and posting your potential answer. I really appreciate it! Now I am rather prod of myself, until I got stuck that I was able to create what my boss wanted. There are 2 departments that use this sheet: Transformations and Management. Now when it comes to the 1st phase,…
-
How do I make this formula count blanks?
Hi, How do I make this count blanks? =COUNTIFS({Range 2}, "name", {Range 1}, "30 days", {Range 3}, "Ready Re-insp" {Range 3}, "ISBLANK")) I've tried Range 3}, " ")) Thank you Kim
-
Using MONTH in a formula
I'm trying to pull sales by rep, stage and then add a formula that calculates the current month. I've been trying but failing to get the "MONTH" formula baked in but keep getting errors. My current formula is below - how do I get it to grab the current month from the "Expected Close Date" column in my sheet. =SUMIFS({Sheet…