-
What is the best way to copy Workspaces
Hi everyone, I am looking to create copies of some of my Workspaces and am facing 2 different issues. The 1st issue is I have a large interconnected Workspace with over 200 items inside it. I need an exact copy and don't want to relink everything as I would need to do this multiple times and would be days of work. The 2nd…
-
Current Week for Period
I'm trying to use a formula to identify the "Current Week" in my file. The file calculates the reporting period based on the date the new row is created. It also calculates the reporting week number based on the period ending date. The issue is that when I use the WEEKNUMB function to calculate the "Current Week" it does…
-
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…