-
Can I use a button instead of a link?
Our training department uses a smartsheet embedded in the intranet for its training calendar. Click on a class and the description pops up with a link to the registration page. I'd love to replace that link with a SIGN UP or REGISTER button. Is that possible? (I'm brand new to Smartsheet, by the way.) Thanks! /shel
-
Formulas and Reports
Hello everyone This may be a simple fix; however, I am fairly new to Smartsheet and any insight would be appreciated. I built a report that is linked to three different sheets. They were originally imported from Excel that way the formulas would carry over easily. When I pulled everything together, the three rows that I…
-
Page break / separation between years / header
We have a pipeline report pulling data from a primary sheet that we need to separate out by year. Is there a way to add a row or page break to distinguish and separate the two years? Also, In regards to header row at top of reports is there a way to make the font larger and the width of the column itself larger in just the…
-
combining sheets
Hi, everyone! I would like to create a sheet or report that combines all of my other sheets so that I can look at them all together and sort by task. Ideally, this "master sheet" would update as each individual sheet is updated. Any help is appreciated!
-
automatic notifications when dates are passed
We created a new sheet for tracking our work and have a cell with a due date for design submittals. There is an empty cell next to the due date that we want the user to add either a check box or date to show the submittal was actually done. The question is, if the date or checkbox isn't filled out after the due date has…
-
Select a cloud service folder for attachments
I would love to use something similar to the existing Box, One drive, etc, integration to be able to select a whole folder to attach rather than just individual files. When a new file was added to the folder in Box, it would also be available in smart sheet.
-
Sheet Column References in Equations
Is there a way to convert a column reference to a number like you can in excel? My problem is I'm to trying to input an equation that is a simple sum equation referenced to an input cell "x". Whatever number is put in for "x", will add to the column length that sum equation is good for, however when I try to do this, I get…
-
Gantt Report for Several Sheets - Can I drag & drop dates in the report?
I would like to be able to drag & drop Gantt dates in my report as we have several projects going concurrently, and the report is great for big picture. How do I do that? Also, how do I reflect a pause in a project, as in we're waiting for info from a client but are working on other jobs in the mean while? I would like it…
-
Sorting tasks then go back to original layour
I have several projects i keep on one sheet. I would like to sort them by due date, update items in the most pressing and return to my original nice layout that has all of the projects with headers and then the items to work on under each heading. Whenever I save a change after sorting by due date, I cannot get the…
-
Human Resources Time Off Requests with Functionality
Hi, I found 2 templates on smartsheets for time off, but neither work, and I have attempted to customize to my needs and I am not able to figure it out. First I want a form that employees can submit their leave, Second create a workflow for approval, and Third be able to tally the balances automatically to the appropriate…
