-
#invalid value on formula
please help me; this formula is returning an "invalid value. The column is a Date =IF([Date of Last Invoice]@row < DATE(YEAR(TODAY()) - 2, MONTH(TODAY()) + 6, DAY(TODAY())), "Inactive", "Active")
-
Metric by Month
Hello! Appreciate any formula help as always! Currently, we have several people fill out a form and on that form is an "Escalation date" which is just the day they are submitting the request. For example, in May, we had 20 escalations submitted and the actual sheet has those 20 rows with the escalation date column being…
-
SUM
In sheet summary, how do I sum up a column?
-
How to automatically create a flag based on text criteria in row
Hi there, My team is trying to integrate Smartsheet into their workflow. They are moving from a excel based contract rights tracking system into the Smartsheet ecosystem. Traditionally they've been using a legend and color coding row data for cell values that are 'TBC' (to be confirmed), I've been playing around with the…
-
Pending Update Request Icon in Sheets
Good Morning, I have a sheet that has automations for update requests when certain criteria is met. On one of my sheets it has an icon for one of the rows indicating there is an update request, however, the update request has been completed. Anyone know why it would still be there? Thank you, Cara
-
Recurring tasks that need their due date to update regularly
Hello! I am creating a sheet to manage our facility life safety inspections. Some of them occur monthly, some occur weekly, others semi annually and others annually or more. What I am hoping to do is create a formula that will update the due date to the next date, after the current inspection has been completed. I plan to…
-
Formula for unique job number
Is there a formula I can use to create a unique job number where the prefix is the last two numbers of the year created (i.e. 23-0001 for 2023 and 24-0001 for when it is 2024)? If preferable, can this be done in a formula rather than needing a column for the date created, auto number etc etc. Thanks!
-
Duplicate Row
UPDATE: I figured it out :) Hello! I am trying to get a row to duplicate if one column meets certain criteria. So if the cuff size is listed as large we need to duplicate the row to let the vendor know there is an additional item to be ordered, which has a separate SKU and price, how would I go about doing this? If Cuff…
-
Combining If and AND statements
I cannot seem to get this formula to work no matter how I set it. I am trying to combine three columns to get an outcome. If CK Type is Hypertension AND Ed language is English, AND Cuff size is Large, then the outcome would be "Hypertension English Large" There are 4 possible outcomes. All data in the screenshot is made…
-
COUNTIF FORMULA HELP
Is there a better way to pull only the previous year data? COUNTIFS({M&A Program Interest}, CONTAINS("Buyer Consult", @cell), {M&A Intake Form Range 1}, @cell > TODAY(-360) Current formula above