-
I have a column formula applied to a Status Column, however it is not applying to one of the rows.
The column formula is: =IF(Progress@row = "Complete", "Blue", IF(Progress@row = "Upcoming", "Green", IF(Progress@row = "Ongoing", "Green", IF(Progress@row = "Commenced", "Green", IF(Progress@row = "On Hold", "Yellow", IF(Progress@row = "Discontinued", "Red", IF(Progress@row = ".", "", IF(COUNTIF(CHILDREN(), "Blue") =…
-
Is there a way to capture seconds in the last edited column?
I would like to get the last edited timestamp column as mm/dd/yy hh:mm:ss.ss as opposed to the standard mm/dd/yy hh:mm. For example I would like 08/13/24 13:53:47.89 instead of the normal way that smart sheets rounds numbers to the nearest minute.
-
Finding top 5 results and showing top sub result under those top 5
Hi I work for a sales company's and would like to add the top five agents names to my dashboard, under each agent i would like to have their most sold product. Is there an elegant way of finding these agents and their most sold product from the grid that i update every morning? Ideally i would like to avoid creating a…
-
Check a box for duplicate rows, if also duplicate responses in another column
Hi! Hoping I can get some tips on a formula I am struggling with. I am trying to mark a check box based on if I have duplicates, based on two columns. I am trying to identify duplicates between two rows by doing the following; (1) check entire sheet in one column for the same employee ID number (EID), and then for the rows…
-
Formula Needed for Calculation Sheet
I need a formula for a Calculation Sheet I use for Dashboards: Main Sheet Name: Migration Grid 03.29.23 Columns Used: "Type", "IDENT $ - PAH (ATL)", "IMP $ - PAH (ATL)", "VALID $ - PAH (ATL), "Status", "Actual IMP Date", Type Column must EXCLUDE: "Optimization", "Cost Avoidance" Status Column must EXCLUDE: "HOLD",…
-
Resturant management
Is anyone using Smartsheet to run a restaurant financial management? And other related topics I am thinking to utilize smartsheet for cost management, revenue, inventory, assets management. Any thoughts where to start? I have a background in using Smartsheet to develop templates and use reports to form numerical…
-
Dynamically choose what column to sum if in another sheet
I am trying to build out a scheduling tool for my team. On one sheet (source), they can add all the jobs/staffing/hours. The other sheet (total) I want to sum total hours by week for each team member. I could create a Sum Collect and do a separate range for each week. However, I have the week # on both sheet, so am hoping…
-
Parent rows with children in a report to look like a filtered sheet
Hello, I'm looking to have a filtered sheet like experience (picture A below) in a report with a parent and child look, but everything I have tried doesn't get me there. The goal is to have the parent info and be able to expand or collapse the children so they aren't lost at the end of the report when you pull the…
-
Would auto number duplicate a value if a row is moved to a different sheet?
Hello, I currently have a sheet that assigns an auto-number value for each row. Upon certain actions taking place, this row then gets moved to a different sheet. Because that row got moved, would that free up that specific auto-number value to be used again? I am hoping not as we are looking to use this as a unique…
-
How to add duration to manually entered current expected date without adding weekends?
I am adding a column to my plan titled "Current Expected Finish". This column will be used when a task is going to be behind. For the first task behind, an expected finish date will be added to this column. I then want to automatically calculate how that affects the remained of the task. To do this, I want to take the new…
