-
How do I include field changes in an email (Automation Question)
Hello: I am creating automations for several of my SmartSheet projects. I have successfully created an automation that alerts me when there are changes to any of 5 critical values in a row within my sheet. However, I am trying to determine how to include which of those 5 values changed in the alert email.
-
Export with formulas intact
Hi guys! Is there anyway to export a sheet into excel and still have the formulas intact? Currently, exports only show values. Thanks!
-
Outo populate a field on a form when the form is being fill out
hi, is there a way that in a form i can have a way to outo populate a section (let say name ) when the fill out their information. Specially if I already have an IF function that does it in the background? For example: if the person adds a specific number it will show am specific name, pulling it from the the IF cell in…
-
Help for INDEX/COLLECT with multiple criteria
Hi everyone! I usually use INDEX/MATCH, but I am trying to "match" multiple criteria and found that it is better to use INDEX/COLLECT when dealing with multiple criteria. I keep returning "#INVALID VALUE" and am confused what I am missing… I have an "Audience" sheet my team is using with employees' respective name, ID…
-
COUNTIFS
Hi, I have this formula below but its picking up everything that contains small fixes. We have small fixes, small fixes delivered and small fixes closed but I would only like to find results that are small fixes only. Can you help? Here is the formula I have =COUNTIFS({TL}, FIND(Metric@row , @cell ) > 0, {IS},…
-
Sumifs formula application questions
I'd like to apply for sumifs formula in sheet, but seems the function cannot capture the correct sum amount, details as following: Expectation：sum up total service fee from legal entity: 137 with quarter: Q1, and I list the sumifs function as below： The result from the above formula comes up as 55527.49 while the correct…
-
COUNTSIFS does not Contain
Hello, I've put together the following formula, to count certain items in a different sheet that don't meet certain criteria, please see below. =COUNTIFS({SE-Region}, Region@row, {Status}, <>"Completed", {Status}, <>"Canceled", {Status}, <>"Duplicate", {Summary}, <>CONTAINS("Onboarding", {Summary})) The formula works until…
-
Need help with an Index/Match using TEXT for Dates
Can someone help me understand how I can correct this formula? It's returning Unparsable. =INDEX({Revenue & Opex | ARRONI Row}, MATCH(TEXT(DATE(YEAR({Revenue & Opex Go Live Date}), MONTH({Revenue & Opex Go Live Date}) + 11, 1), "MM/DD/YYYY"), {Revenue & Opex Date Header}, 0)) The formula is indexing a full row. Matching a…
-
Iferror using multiple sheets
Hello, I have a sheet titled "4G Cradlepoints" with the serial number in the first column, Column name is "Serial Number". Each serial number is listed once. I have another sheet named "All Sites" and the 60th Column is named "4G Cradlepoint SN". The serial number will be listed multiple times in the "All Sites" sheet…
-
RBG and Gray Formula
Hi All, Can someone please help me correct this formula? The grey color is not coming up when the status is "on hold" and instead green is coming up =IF(Status@row = "On hold", "Gray", IF(Status@row = "Complete", "Green", IF([End Date]@row < TODAY(), "Red", IF([End Date]@row <= TODAY(14), "Yellow", "Green")))) Thanks