-
Send Email when any Cell except 1 changes
Hello, Is there a way to send an email when any cell except one changes? I have a field called job status. I need it so that if any field except job status is updated to send an email. What would be the best way to go about this? Thank You, Douglas
-
Any update of adding a comment/note to a specific cell?
Adding a comment to a specific cell would be helpful. In our case I've created a cash flow sheet and one row shows weekly income per column week. This cell shows the total of the checks received. I need to see which checks were deposited. Is SmartSheets looking into adding this function?
-
Adding months onto a date
Hi sorry I have seen this posted multiple times before but I can't get mine to work. I am trying to add the number of months in the "Monthly Review Frequency" to the "Previous Review Date" in the "Next Review Date" Column. I have tried this formula: =DATE(YEAR([Previous Review Date]@row), MONTH([Previous Review Date]@row)…
-
Updating a status column based on Values in Expected % Complete and % Complete
I have dates from two columns, Expected % Complete, and % Complete which I want to use, and populate the Status Column (Dropdown) using Formulas: The Dropdown options are " Not Started", "Behind", "On Track", and "Complete". I tried using the below formula =IF(AND([% Complete]@row = "100%", ([Expected % Complete]@row <…
-
Change cell value based on 2 values of other fields
I have a form that asks information of faculty about the rooms they use in our building. I have data from last year's process in a separate sheet. Presently, using automation, I'm copying rows from the intake sheet/form into a new sheet that already has last year's data in it. There is a question in the intake form/sheet…
-
Cross-sheet referenced Date keeps defaulting to non-Date format
I have a column that uses 3 INDEX MATCH(es) to pull in a single date (there is no way this will ever pull in more than one date) using IF statements and "" if it is not found on a sheet. Formula works as planned, and I now have a System Column of "Created On" in my data (first pic). I can then change it to display as a…
-
Add IFERROR to formula
Hello, I have a tricky formula question. If I want to add a IFERROR to the following formula where would I go about inserting it? =(((IF(LEFT([End Time (HH:MM)]@row, FIND(":", [End Time (HH:MM)]@row) - 1) = "12", IF(OR(FIND("a", [End Time (HH:MM)]@row) > 0, FIND("p", [End Time (HH:MM)]@row) > 0), 0, 12), VALUE(LEFT([End…
-
Formula Help....
I have two columns one for product description and the other for units sold (about 1000 products in total), and I want to use a sheet summary formula to return the title of the best selling product.... any ideas? ideally I do not want to use helper columns in my sheet
-
INDEX/MATCH find some but not all. Mixed numbers and letters in MATCH fields
Any ideas why I'm getting no results for 305WI001 and 209WI007? Here is my formula: =INDEX({DQDs in Review Doc Group}, MATCH([DQD No.]@row, {DQDs in Review DQD No.})) It seems the DQD No. with a "WI" returns no results but the rest do. I've checked my source data and there is a Document Group designated for both 305WI001…
-
Countifs & Contains formula help
Hi I have created this formula with cross sheet references but it is not working and I do not know why! Help appreciated please? Each column reference is looking at a full column and all searched are a partial searches of what data is in a cell ie "Platinum Central" is only part of the name in the cell. =COUNTIFS({Schedule…