-
Is there a way to have the rows automatically sort ascending by date when new rows are entered?
I have a job board created that jobs are added to and dispatched from the problem is if the jobs are not ented in order by date then I have to manually sort each time. This is a 24/7 process mostly accessed by mobile devices so sort is not an option.
-
Automatic blank top row
Hello, Currently when I type into the last row of a sheet it adds a new blank row on the bottom of the sheet. Is there a way to basically reverse this so that the row is constantly added to the top of the sheet?
-
Chart Columns
Notice in the attached picture that I have a chart that shows how much reimbursement a specific client received last year and as of the current date the client has received almost half of that. The issue is that the FY1718 (Red) column appears too small for the actual result. Visually, shouldn't it be about half the height…
-
Risk Management Plan
I am creating a RM plan using the SmartSheet template. What goes into the Sections Impacted & Distribution area of the document?
-
Dashboard
How can I create an A0 landscape dashboard canvas
-
Developing a Matrix Questionnaire
Hello, I am hoping someone can help me design this type of Survey Form to send out to my work employees. I would like to ask them to pick an answer (that I give them), by selecting the radio button. It seems easy enough however, I do not see this. I have attached a screenshot. If you know how to do this, I would really…
-
Populating Parent with Child Cell Info
I am new to Smartsheet and was hoping someone can help with this logic expression, or let me know if this is even feasible. We inspect equipment (blue light emergency towers) bi-weekly. I would like to create a sheet that shows these inspections and automatically creates a work order/assignment for our various repair…
-
Pull from another worksheet IF criteria is met
I think I need an IF formula, but what I'm trying to do isn't working so far - so I reach out to the community! I want to pull information from sheet A (client name, phone number, e-mails, what they purchased, etc) which is the master list of all the clients and what they purchase, to sheet B (to schedule work, this is a…
-
Decision matrix template?
Hi all, I am new to smartsheet, and have created a decision matrix style spreadsheet to compare special schools for my son, giving ratings according to different criteria. I want to then be able to work out. Instead of stumbling along to work it out, I assume someone will have something suitable? If not sure what I am…
-
Include update request button on Alerts
Hello, Is there a way to include the update request on an email alert? We currently send our customers a notifications when they submit a request. What we would like to do is give the customer the ability to update the request without giving them access to the sheet. We also do not want to manually send an update request…
