-
Creating Conditions that affect other rows
Hello, I am super new to smart sheets, but have done very well with 99% of what I have needed to accomplish, however… When trying to create a condition labeled "Yes | No," and if Yes is selected in that row, then I want it to highlight another row also in the primary column to red to highlight it being the next step to…
-
Convert VLOOKUP to INDEX/COLLECT?
Hi, I am trying to calculate the fees for a project based a list of fees from another sheet. My current formula works when only one product is selected but does not work for multiple products. Would converting this to INDEX/COLLECT work? And if so, how would I do it? Current formula looks up the value in Project Type/Scope…
-
Can I turn comma separated lists into multiple-choice dropdowns?
The title basically says it all. I have a column that was built in Excel, with multiple items separated by commas (no spaces) to make a string of about 1-5 items. We're moving our processes into Smartsheet, and I want this information to be formatted as a dropdown column with each item chosen as a separate entry.…
-
IF formula from Excel to Smartsheet
Hi, I currently have a spreadsheet in Excel I am moving to Smartsheet with an IF formula. Can someone help translate what this formula should be in Smartsheet? In Excel, the Current Widget Liabilities formula is: =IF((2023 Paid Widget Balance + 2024 Paid Widgets - Widgets Created in 2024) <0,0,(2023 Paid Widget Balance +…
-
Collect values from another sheet
I have a worksheet with 5 columns that are multi-select dropdowns. The dropdown for each of the 5 columns is exactly the same; 400+ Store #'s. I would like to collect in another sheet ALL of the selections from one column and compare those to the actual list of Store #'s. The object is to identify if a store # has been…
-
At Risk Function using date midpoint?
Hi everyone, I'm hoping someone can help me here - because I'm completely stuck. I'm working on building an equation that flags something as "at risk" if the following conditions are met Project Status is "In Progress" The halfway point between the Project Start Date and the Project End Date has passed. Percent Complete is…
-
Help with Countifs
I am trying to figure out the formula for my metric sheet. I am wanting data to populate based on a date column and a column that allows for multiple selections (comes from form). Here is the sheet that my form dumps into. So, I am refencing the date column and the column on the right Where they can select 0-30ish things…
-
Need help hiding checkboxes
I have a handful of project intake sheets, that ControlCenter looks at to automatically generate project files if approved. We have 2 types of projects that are intermingled on the sheets, and use 2 automations in CC. I'm now running into an issue with some users checking both approval boxes, and CC generates 2 sets of…
-
Why is December's NETWORKDAYS formula not calculating correctly?
Hi - I have this formula that works perfectly for the year, but when I get to December it is calculating an odd negative number. Can anyone help me understand why and what I need to do to correct it?
-
Creating a simple sequence formula for the column
Is there a simple method to create a sequence column in a helper sheet based on a specific number to start the sequence? To give an example, I want to sequence start with the number 25 and increase each row by 1 (ie. 25, 26, 27, etc.), not by any specific project or identifier, simply starting with 25. I thought selecting…
