-
Finding the earliest delivery date based on Material code as the criteria using MAX(COLLECT
I have a source sheet which is basically a delivery schedule for all materials with multiple delivery dates, what I want to pull to the target sheet is the earliest delivery date of that material code. Currently I have the following formula which doesn't seem to work! =MAX(COLLECT({EDD}, {STYLE}, [MATERIAL CODE]@row), 1)…
-
No result when value from a formula is used as input to WORKDAY formula.
Hi, I am calling value calculated by a formula in WORKDAY function. but it is fetching/giving no result for the WORKDAY calculation. Can any one please help on this?
-
Rank Function
Hi, How do I create a rank formula for the field, that only includes certain values from a row that meets certain criteria. For example the below image is the example. I only want to rank and include in the range active expenses. Can someone please help me.
-
Formula to auto calculate due date
I want to auto calculate the due date for monthly stock inventory. For February it will be 28 of the month, for the rest of the month to be 30th. Would appreciate your assistance. Thanks.
-
How to use SUMIF and the criteria is a range of values
Hi Everyone! Can anyone help me with that. I'm trying to use sumif function for a range of values. for example: I want to sum a values in a column if they range between 50 and 60. How can I do that? I used: = SUMIF( mycolumn, AND(mycolumn >50 , mycolumn <=60)) but its not working. Thank you
-
Using Or to Reference to Different Columns
Good Evening: Not sure how to add an Or to my Formula that Reference 2 Different Columns. I would like to add to my Count if the Id Column has Analysis or If the Issue Type Column has Task Current Formula which Returning an Error: =COUNTIFS({Sprint}, "ACAMS 2.0 SF - Sprint 9", {Bus Status}, "Done", {ID}, "Analysis", OR(…
-
Automating alerts based off date modified
Hi all, I have read a number of posts about creating alerts/reminders based on a modified date column, but I haven't found the answer I am looking for. Maybe you have it? *crosses fingers* I met with Pro Desk on Monday and it was suggested that I use the "Within the last days" option, however this doesn't work because it…
-
Converting a drop down single select list of dates into a date I can use with Calendar App
I am new to Smartsheets and trying to convert a single select list of dates into a format that can be used by the calendar app. I need these dates .. Tuesday, December 29, 2020 Wednesday, December 30, 2020 Thursday, December 31, 2020 Monday, January 4, 2021 to be used to enter events into the calendar app for requests to…
-
Date to move ahead 1 year from scheduled due date, unless RYG ball is "Not' Green
Hi, I am hoping someone could help me figure out how to create a formula to calculate the date, 1 year from a date selected if my RYG ball is "Green". This date would consistently be rolling toward the future unless an RYG ball is "Yellow" or "Red". I am working on a maintenance sheet, which we will be getting every piece…
-
Using Dates for Summary
Is there a way to use a date (like 08/1/2020- 08/31/2020, etc.) to a total count on a destination sheet? I have a source sheet with the data I want to connect to a report that will give Monthly totals for multiple hire types (hires, terms, and contract) and by job code. I can provide more information if needed.