-
Drag-fill not working?
Hello, I'm trying to create a list of dates. I need 01/01/21, 02/01/21,03/01/21, and so on. However, the drag and fill function doesn't cooperate. How can I get it to follow the pattern?
-
Cross Reference Continuously
I was able to use a formula previously provided to allow my pages to talk to each other; INDEX=(thecolumwiththevaluesiwanted), MATCH(thecellwiththevalueiwanted), (thecolumwiththevalueiwantedagain), 0) however, it was not continuous where updating the original page would update the corresponding spread. Is there a formula…
-
Is there a way to test to determine if a row includes an attachment?
We would like to be able to send users a reminder that they forgot to attach a file without having to open Smartsheet, look for the attachment and send an update request if the user fails to attach the needed file. Since I can't find a way to reference attachments in an if statement, is there any other way to determine if…
-
Need assistance on #Invalid Operation result
I'm trying to create a formula in a parent row to return the most common value of its children (High, Medium, or Low) and keep getting an #Invalid Operation error If there are equal or more highs than mediums or lows, the parent status should be High. If there are equal or more mediums than highs or lows, the parent status…
-
Sumifs to count color symbols
Hello, I have a spreadsheet where I am tracking initiatives by team for each month and there is a color assigned to that initiative. For each month I assign these colors. I have a total of 12 columns. Green for on track, Yellow for at-risk, Red for breached, and Gray for not started. I really wished I could add one more…
-
I keep getting and invalid data type error for my VLOOKUP formula
I have to sheets in my workspace, one contains system generated authorization numbers, and the other tracks requisitions. I want to populate the credit card authorization numbers from one sheet onto the requisition tracking sheet. I am using the following formula. The value returned is a combo of number and text. The…
-
COUNTIFS and OR statement together?
I have several countifs together and I need to add another set ("Status" column that states "not started" or "in progress"). Everything I've tried has not worked. =COUNTIFS({Vendor Category}, $[Primary Column]@row, {Help}, "assistance needed", {status}, "not started OR "in progress")
-
Help w/counting cells with blanks with OR statement
Team - I have a sheet that has 5 columns that are used for answering specific questions: I also have other columns that are used to verify information: I need a formula that will return a count if any of the 1-5 questions are blank OR the Cyber Intel Verified is not checked OR the Cyber Intel - follow up required is blank.…
-
rank(collect function to rank based on multiple columns
Dear Smartsheet, I wrote a function and tested it on this sheet, it should rank to also find the latest component installed based on Position & Component and then rank 1 for the most recent install date (lowest days since install). It works in this sheet with formula: =RANKEQ([Days Since Install]@row, COLLECT([Days Since…
-
Formula to Automate Dates
Hi! I am looking for a formula for my "Actual End" Column that will auto-fill the date when the "Assigned To" statues a task as "Complete. Can anyone help with this? Krista