-
Clear RYGB balls on completion of a task
Hello, Currently we are using the RYGB balls as a priority indicator. One of the things that happens when you are completed with the task is that you have to clear the ball manually. I would like to automate the task. <Column 1> RYGB <Column 2> is a drop down with the following "Canceled", "Pending" and "Released". I would…
-
Editing a Drop Down List
I am creating a Tasks List and am wanting to use a Drop Down list to indicate the Client the Task refers to. Our Client list is ever-changing. Am I able to add or delete clients from the Drop Down list without affecting the data in the other Client cells? I am hoping to keep the list alphabetical, so additions and…
-
cell data randomly deletes!
when resting my mouse in a cell, the content randomly deletes (with no action on my part). How can this be stopped? screen recording of deleting - notice Column Title Row 2 - disappears NO ACTON on my part.
-
Indent or minimising rows
Hi, I have several standard grid sheets that are populated via webforms, we are based within the UK. The issue I have is that I don't seem able to include "indent" function to the rows (i'd like to indent per month), as the sheets are growing huge as we have a lot of data being submitted from remote and field workers. So…
-
Sorting Numbers with a "-" in it
Hi all, Probably my incompetence here but i have a confusing issue at the minute. I have a long list of job numbers and am trying to sort them in numerical order. There is a criteria that we use to create these that you should probably be aware of: * Primary number is a 5 digit numerical number (i.e.21495) * If there is…
-
Aging Date Average
Hi Community, I am attempting to create a KPI for a dashboard that will capture the average number of days a 'something' has been opened, but only if it is still in an opened state. I can perform the appropriate "days open" with "=IF([Closed Count]3 = 1, NETWORKDAYS([Submitted Date]3, [End Date]3), NETWORKDAYS([Submitted…
-
Linking/adding rows using 2 spreadsheets
Hi all, I am having an issue that might be simple to solve, but I can't seem to find an efficient solution. I have 2 spreadsheets: - One with the ID, name, Lot and several other columns with product specification information - Another just with the same ID's, names and Lots, and a few bits more that don't pair with the…
-
Rollup percentage in project schedule template is not calculating correctly
I'm using the project template in smartsheet, in grid view. I've broken my project up in several phases, each phase a parent with child tasks. The Project % complete is coming out as 99% complete, but it is far from being that complete. Is there something I have to do to get this to calculate correctly, or do I have to…
-
Capturing Date of Transaction
Greetings, I would like to capture and freeze the date a drop-down column gets changed to "Picked Up by Customer". I tried modified date but that field gets changed too often to accurately reflect the state. Essentially, I want to know how many widgets were issued by date they were issued without looking at each cell's…
-
Check Box Column Property Not Working
I feel silly asking such a basic question, but it's got me stumped. Normally, under Column Properties, when I select Check Box, a box appears in the column as it should. However, no matter how many times I've tried, no boxes appear. It seems to remain as a Text/Number. Has anyone run into this? Thanks!