Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please
Visit the Current Forums. Archived 2017 Posts
Archives for November 2017
Discussion List
Can sheet EDITOR make sheet "invisible" for a period of time?
I have a sheet for which I'm the owner and I've shared it with 10 people in a workspace. I have one collaborator whose permission level is "Editor -- can share" and I'd like that person to be able to temporarily "check out" or make the sheet invisible to other users while she's making her changes/additions. I know that the…
Continuous Formatting
I have a sheet that is used to log data. New data is added several times a day. The sheet currently contains data through line 2223, however I can only format the next 20 rows because that's all the more the sheet will allow. Once I've entered data into line 2243, another 20 rows will be available to format. Is there any…
Drop down list at the cell level
Hello, Is it possible to create a drop down that is held within a cell level or are all drop downs required at the column level? We want different potentials for each cell in a column as apposed to one large data set. Thanks!
Is there a way to auto-populate a field on a form to match the same field on another form?
I'm trying to create a 3-step, or 3-page, Production Order for commercial production. One page would be for client info, one for script details, and one for editing details for each commercial. I have it set to automatically take the user to the next step once they hit submit. So each step (Parent Row, script, each edit)…
Sights font size
Hi, Is there any way to choose larger font size than 36? I have a large 50" screen which shows 5 tiles with 4 rows of data, that is updated every minute (since today's enhancement of auto-update). It works perfectly! Love it! BUT: The biggest font is 36, so numbers are visible from couple of meters, but if I step further…
dependent actions
Can actions be made to be dependent upon another action? For example - Can I trigger an action to occur when a specific button is pushed and have the action affect a specific field in the same row as the button ? - specifically , I am wondering if I can populate a field with the current date (say field 3) when the button…
Tracking overall attendance to event
Building 2 different pages, one for general registration throughout the year, another to Track which companies have been to which events. The Registration is coming easy but how do I get it to fill in the Tracking sheet/report? So the Registration will track all the attendees for an event, of which there could be 1-10…
% allocation
I have read a few posts regarding the inability of the tool to automatically update duration based on changing % allocation of a resource i.e. Task A will be completed with 1 day duration by Resource X. I change Resource X to 50% allocation and the duration should automatically be updated to 2 days. The last post I read…
add [date](summary of projected days to [Number of days]
add [date](summary of projected days to [Number of days] Is there a simple formula to this . =[Site Walk Schedule Date]1+[Projection Totals days]6 =11/1120177.777 its adding the the date as a number instead of date 11/11/17 to 6
Sheet notifications
I have been getting a daily notification by email of sheet changes for a while and that has been working great. After one of the smartsheet updates it also started appearing under notifications in the top right corner. That notification is redundant to the emails. Is there any way to turn it off?