-
MAX/IF function
Hello all, I am trying to use the MAX/IF logic in smartsheet. It worked for me in excel: I used the same logic from above in smartsheet: And I get this: Any ideas? Appreciate your help in advance. Thanks!
-
Workflow automation for when a cell in a column does not change status
Trying to see if there is a work around for setting up a workflow automation to trigger when a status column does NOT changes status from planning to in progress after 14 days. I only see triggers for when a column or row has changed, but nothing for when a column doesn't change. Any suggestions?
-
INDEX(COLLECT Returning #Invalid Value
Hello, I am getting #invalid value witht he following formula: =INDEX(COLLECT({Purchase Quantity}, {DepartmentConsolidation}, "112", {Consumables}, $[Product Description]@row, {Purchase Date}, >=[Week Start Date]@row, {Purchase Date}, <=[Week End Date]@row), 1) There is definitely a match on the sheet and if I remove "…
-
Formula to Use
Hi, I'm trying to figure out how to write a formula that would add the numbers in the "QTY" column that also match the selected "Replace in Fiscal Year" dropdown selection. The top rows 24-29 is where the totals would populate based on the matching of the "Replace in Fiscal Year" selected and "QTY" sum in the corresponding…
-
COUNTIFS using an OR with a column hosting 2 variables
Hello, Trying to set this formula to count 5 items using vlookup. The issue I'm having with that of the TYPE column hosting 2 distinct variables. I am not well versed but believe this needs an OR option. Curious if someone might know the best approach here. =COUNTIFS({HUB ERP - Function}, "Data", {HUB ERP - Status}, "In…
-
Count dates within a specific range
I am collecting performance data for my project. I have a report that contains all of the data I want to analyze and report statistics on. I'd like to look through a column containing dates including some empty cells, and count how many cells contain dates within a specific range. I'd like to count cells containing dates…
-
Alert recurrence that looks at a date field - possible?
I'm trying to set a recurring alert workflow to remind someone that they need to approve a submission. I have a "submission date" field and I would like a workflow that sends a reminder one week after submission date is reached and then weekly after that, as long as the status field is not changed to "approved". I was able…
-
How to return results between a certain date range
Hi I am trying to find a formula I have a master sheet that I would like the total days of holidays of employes for each month to show on a separate sheet. eg May total 5 days Any Suggestions welcome thaks
-
Count rows based on Date and Value criteria
Hi, I'm trying to count the rows in a sheet that have two criteria. I'm using the formula in a Sheet Summary field. The Date Initiated column cannot be blank and the Risk column is at High. Here is the formula I've tried with some variation: =COUNTIFS(Rating:Rating, "High", [Date Initiated]:[Date Initiated], ISDATE@row)…
-
Best way to make cells automation
Hello, I'm wondering if in smartsheet it's possible to create the following automation: Row: Product name Column 1: Stage (Drop list: Sourcing, QA) Column 2: Task (Drop list: RFQ, Negotiation, Test) Column 3: Start date Column 4: End Date If I choose (Stage) Sourcing > (Task) opens only RFQ, Negotiation options; start and…