-
Conditional Formatting
Hi I am hoping someone might have a simpler solution than the one I am thinking of. I am creating a sheet for my company to track all of our projects. The scope of what we do for each project varies based on what kind of campaign it is. There are 10 different kinds of campaigns, so say for example Campaign Type A might…
-
Linking Sheets
I am working on a master SmartSheet to roll up other Sheets into one. When changes are made in the linked SmartSheets, this is not reflected in the master. If I add additional rows, my master is not updated What I am missing?
-
Count specific total number grand children rows and ignore higher rows
Hello All, I am tracking different sessions being hosted between employees. The sessions are the rows with the white background. I want to dynamically count the total number of sessions that are happening for row 2 "IMC". So I need to count the number of children of row 3 "IMC Common Architecture" as well as the number of…
-
New UI 12-14-2018
This UI is terrible, I don't even want to waste my time explaining why at this point, it is OBVIOUS. At this time I am contemplating updating all training materials, SOP's and videos or just throwing in the towel and searching for a replacement. I simply do not have the time to re-learn, re-document, re-train every time…
-
Score Formula
I've created a scorecard in smartsheet and want to create a formula that does not allow the scorecard score to show as more than 100%. I think is should be something like If score >100%,100% but am not sure what the entire formula should be.
-
Linking smartsheet
I have a master sheet that I am using to pull in data from the child sheets (linking). The child sheets are dynamic and new parents and childs could be added. 1. When linking i lose child sheet hierarchy on the master sheet. How do i maintain hierarchy? 2. When new tasks are added (with hierarchy) how can i keep the master…
-
Identifying and returning phrases within a single cell
Hi all, I have been trying to figure it out alone but I thought I'd engage the community to see if anyone can help! I have a column in my spreadsheet that contains phrases separated by commas - for example (though with different words), in one cell it says "Phone, computer, mouse, cell phone, water bottle, earphones, bag."…
-
IF Text in any field between multiple columns, then equals text value
I am having some issues using the "IF" formula. I'm trying to make it so if ANY VALUE is in the "CUT, FAB, WELD" columns then it will output the text "In Progress" to the "STATUS" Column, and if there is no value in any of the columns then the "STATUS" column will say "Not Started". Along with this, I have a checkbox in…
-
Value function
Having trouble with the formula below. Version 1 works and extracts what I need from a cell. I need to then convert that to a numeric value. Currently I get #invalid value. I'm missing something, and I bet it's dumb. ;) * =MID([Active Link]@row, (FIND("/", [Active Link]@row) + 1), ((FIND("*", [Active Link]@row) - 1) -…
-
Count if dates are within the next 7 days
Hello, I'm trying to use the COUNTIFS function to search a reference column full of dates to count how many are within the next 7 days. For the criteria portion of the formula, I've tried using, "<TODAY(7)", "<TODAY() + 7", but they are not providing me with the correct (if any) result. I would like to avoid having to…
