-
Survey for each client project (multiple forms one sheet)
I have a set of surveys which we have been sent out through smartsheet, each on their own sheet. At the end of the year, I am required to export all results and consolidate them for a year overall report. To help streamline this I have created multiple forms in one sheet for this year. What I need is to be able to label…
-
how to define who the approval is from multiples
I have migrated our Engineering change to smartsheets which is working fine. I now want to progress this by adding approval requests. We can get changes approved by 3 different people, so I have created an approval request which gets sent out once a box is checked to declare the change is ready for approval. At present…
-
Counting RYG Balls
Hi guys, Is it possible to count the number of balls according to their respective colors? Many thanks in Advance.
-
Am I the only one who does not like the new December 2018 look?
I'm struggling with the new layout and welcome any suggestions. I do not have the dashboard level subscription - just below that, I think. I HATE that I have lost my tabs, and I hate that the menu button ALWAYS takes me back to the RECENTLY VIEWED as opposed to the Home. This new layout just seems like more work to manage…
-
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."…
-
INSANITY or EMPLOYEE EGO or MANAGEMENT INATTENTION??
I have seen some of these head-in-the-clouds people at Microsoft do some really stupid "improvements" but this tab thing takes the cake. I am a shareholder in this company and am considering selling due to management's inattention to their business. Good management would never let a thing like this happen.
-
Keeping persistent dates for status changes
Building a kanban board with typical IT cycle states: Ready, Dev, Test, Deploy, Done. I'd like to track cycle times and throughput. I've created (locked) columns to capture a status change for each of the cycle states; e.g. Dev Start and formula "=IF(Status@row = "Dev", TODAY())". That works to capture the date that a task…
-
Nested IF(ISBLANK & Date Columns w/Progress Bar
Hi Everyone! I would like to know if you are able to use date columns when automating a progress bar. Basically dates are entered as product moves to a new stage in the process. As the dates fill in, the progress bar fills as well. I've used nested IF formulas for automating a progress bar but, for whatever reason... Im…
-
Smartsheet Maintenance
What is the Smartsheet maintenance plan? How often do they do maintenance? Do we have the option to not select the updates?