-
Date Range Formula Help
Can someone please help me to create a formula that returns the number of items with a "Permit Expiration Date" between 7/1/20 and 7/31/20 AND has the "360 Photos Have Been Submitted" unchecked? I've tried several "if and" formulas and they didn't work :( Thank you!!
-
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…
-
Finding date in other sheet and adding into current sheet
Hi Guys I have a sheet with columns of information. One column has a "container number" which looks something like this "TCNU6307839" A few rows down i need to enter a date for this "container number". This date is entered in another sheet with the same container number in a row. Now I'm manually copying the container…
-
Creating Due Dates (Monthly & Quarterly)
Greetings I have been asked by a colleague to build a smartsheet that sets out a list of tasks to be completed and the due date of each task (to be used primarily in calendar view by the colleague to plan her time). Her due date for a task is either made with reference to: (i) a business day in a particular month (i.e.…
-
Index Match Formula with Multiple Criteria?
Hello, I'm trying to create an index that has multiple criteria. I'm not sure if I should do this using an "IF" formula, or if I need to incorporate the "AND" function into the formula. Or if I need to go in another direction to accomplish this. What I need to do is return the "Rate" based on the "Crew Type", and the…
-
Extract date and Time
Hello, Is it possible to extract a date/ time from an imported excel file? It is currently reported as a string 2020112717161730. Thanks in advance for the assist!
-
Total Count if value matching from multiselect cell
Please help, i have 2 sheets. One sheet (Second picture) contains week no. i.e. the week No (depending on a date) in which a member took leave or was absent. The other sheet (First picture): I wanted to count total week numbers from that column only if week number is mentioned in multi select cell (under Week Number…
-
Return Different Amounts of Characters from a cell
Hello Smartsheet Community, I am trying to come up with a formula to pull the 3 or 4 characters from the beginning of a cell. The Foundry ID is what I am looking for (pictured below), but the lengths varies between 3 and 4 characters. Does anyone have any ideas on how to accomplish this? Thanks!
-
running sum without explicit cell reference
Hi i have a formula that sums values in a column from row 1 to current row =IF(CurrentRecordHelper@row = 0, "", SUM(CurrentRecordHelper$1:CurrentRecordHelper@row)) is there any way to replicate this without the explicit row reference ($1), so it can be converted to a column formula many thanks in advance Andy
-
Convert formula to column formula without losing existing cell data
Hello, I have a sheet where I'm trying to add a formula as a column formula so that it applies to new rows, the issue is many cells in the column already have data (Date column) that I don't want to lose. The formula is an INDEX/MATCH that is referencing another sheet to obtain a modified Date. I have a trigger to copy a…