-
Basic NETDAYS Help!
Disclaimer: I'm a SmartSheet beginner, and only at an amateur level with Excel formulas. I've reviewed quite a few NETDAYS posts on here already and tried variations of the solutions in all, but so far every NETDAYS variation I've tried has returned the #UNPARSEABLE error. I'm trying to write a formula that will calculate…
-
INDEX(MATCH) or JOIN(COLLECT)?
When we first started using Smartsheet, the rep who handled our "Launch Package" created the following formula. =IFERROR(IFERROR(INDEX({SupplierItemNumber-AL}, MATCH($[Our Part Number]@row, {OurPN-AL}, 0)), INDEX({SupplierItemNumber-MZ}, MATCH($[Our Part Number]@row, {OurPN-MZ}, 0))), "ERROR - CHECK PART#") It searches two…
-
Calculate Total % Complete Checked Boxes of all Parent and Child Tasks
Project: I have a massive checklist we use for event planning (700+ rows!) and want to be able to know how far along in the planning we are percentage wise for one particular event. Goal: I want the Parent row %s to be the total percentage complete of all their Children tasks. The parent row is setup as an event planning…
-
Excluding and Including data in a countifs formula
I need the total number of that meets the following criteria - Banner Name, Open, and not MA or NY. I am able to write the countifs to include the specific banner name and whether the status of that site is open, but I can't figure out how to exclude certain states or include certain states. This is what I tried below…
-
Parent Child Numbering
With A LOT of help from the community I was able put this together but, I think there must be a better way. The last column is what I am trying to get to. Auto-generated Sequential number in this format T-00001 when Ancestors = 0 Auto-Generated Sequential number in this format T-00001.1, T-00001.2 (where T-00001 is the…
-
Formula to extract a portion of a name
Hello,, In Excel I would use text to columns to do what I'm trying to accomplish here but I would like to try a different approach. I'm really close but seem to have hit an impasse. I have a name column that is formatted thusly Lastname, Firstname MI. where some employees do not have a middle initial. I want a column with…
-
SUMIFS - multiple criteria refrencing another sheet
Hello - I need help with a SUMIFS formula referencing another sheet. I would like it to sum the tech count column if the request type is "FSA" and the FW01 column is "true" Here is my formula that is currently not working: =SUMIFS({Tech Count Range 1}, {Tech Count Range 2}, "FSA", {Tech Count Range 3}, "true"}) Tech Count…
-
IF(OR(AND?
I am having trouble with a formula. I am not sure what the heck I am doing wrong here, but I know there are some formula geniuses here that can help me lol. I am trying to return a Red ball if the category is an output or project and the expected completion date is in the past. If it's not, I want it to pull whatever is in…
-
Combine two separate contact cells into one cell.
With the new update to Vlookup adding contact list functionality, would there be a way to combine two individual contact cells into one cell with both contacts using an equation/formula?
-
Is it possible to create an "If" statement that includes a hyperlink?
I have a column of data which reflects the status of a project. Statuses include "Completed", "On Next Report" etc. I'd like to embed the report schedule into the cell when the project status is "On Next Report" so viewers can easily click and see when the next report will be published. In my head, this is something like…