-
Percentage completion with limiting value (dropped down list)
I am a new user of SmartSheet. I added a column in SmartSheet called Percentage Completion. And, I would like to limit the input to: - 0.00 (0%) - 0.25 (25%) - 0.50 (50%) - 0.75 (75%) -1.00 (100%) Then, I chose dropped down list for this column. However, this column was excluded in the pull down list of option (% complete…
-
Column showing who approved the approval request?
We have an approval process that allows multiple people to approve an approval request. Is there a way that I can have a column show who was the approver? Right now we have to right click to view cell history to see who the approver is.
-
Error Message: Maximum Number of Computers - What Now?
Does anyone know about this error message or what to do about it? The maximum number of computers that are monitoring the device has been exceeded. Polling to the device will be stopped. To restart polling, set in the [Configuration] menu again after a moment.
-
Not receiving notifications
Hello all... I am fairly new to Smartsheet and this Community but have come across my 1st issue. I have created a Smartsheet where multiple users will be entering data for items to be purchased through our Purchasing Dept. I have created a formula where, when the "Ordered By:" and "Ordered Date" are populated, the "Status…
-
Agendas in the meeting templates
Hi - I'm working in the agendas, and in the template, there's upcoming, past and new agenda submissions. In the dashboard, it has previous agendas and upcoming agendas... How do I get that to update to the next agenda? The first meeting I did is over, do I have to make a new form for the next meeting and link it, or can I…
-
Forms and functions
Hello, It would be smart to be able to add hide field in form with formulas. Actually, forms add new lines, so in a smartsheet where you need formulas you have to add them after. Not very smooth. Right now, to make my smartsheet a tool for users i have to ask them to insert line manually in smartsheet with formulas already…
-
BUG formulas when Inserting a TOP row with a Form
Hi all, Since a few days, there are some issues inserting ROWS with a FORM. see image below, for instance when you insert a row at the top of a sheet, it SHIFTS all the formulas in the entire Sheet ! Any Help is Welcome... Thanks
-
Building Notifications
I want to set a notification when a cell is populated but only one time to let the recipient know the action is in progress, then cease when the action is completed. It seems that my recipient will receive the notification every time a change is made in any column of the row once that cell is populated. My sheet has over…
-
Inventory help.
I am looking to use smartsheet for inventory. I have one item that we stock and I would want to scan the bar code in to record the s/n and when an order prints to be able to scan the bar code removing the item out of inventory. I used the "barcode inventory management" template but it works great for adding inventory but I…
-
Not receiving notifications
Hello everyone, I am fairly new to the Smartsheet app, as well as community. I am having issues with not receiving notifications, when a certain task (column) is populated. I have created a Smartsheet to order materials from outside vendors. There are to be multiple employees adding stuff to this sheet, and one or two…