-
Keeping old and new data when needing approval/decline
We use Smartsheet for forecasting budgets per team. Each team has its own sheet with each line item that rolls up to sheets, reports, and a dashboard (with graphs and metrics). The columns represent both forecast and actual money spent per month (two separate columns per month). When a product owner adds a forecast amount…
-
Percentage of Total Tasked Complete
Good afternoon everyone! I am trying to format my "% Complete" column to auto populate when changes are made to my "Requirements Total" and "Requirements Complete" (i.e. If I have 10 requirements in my Requirements Total column and I have completed 5 in the requirements complete, which would make my "% Complete" column…
-
Equipment Sign Out Form
Hello! I was wondering if someone could help me build a sheet/form combination for signing shared equipment in and out of a warehouse environment. This is the kind of functionality I'd like to get out of the sheet: * Users would be have their name and the date populated in a form automatically * Pieces of equipment that…
-
SUMIF value exists, leave blank if cells are blank (nothing to sum)
I'm trying to figure out how to create a formula to sum a column if there are values, but leave the field blank if there are no values in the range. Is that possible? Here's the background: I'm trying to create a status report that shows whether or not someone has actually entered values into the appropriate column. If…
-
How to print selected columns
I'm new to Smartsheet and I have inherited some sheets from my predecessor. I'd like to print a Gantt chart and a grid. My question is, how do I specify which columns will be printed? When I print the grid it prints all columns I can see on the screen but I want to exclude some. When I print the Gantt chart it only prints…
-
Multiple Attachments in Forms
Hello - I'm currently working with our HR department on utilizing Smartsheet to essentially work as our application. I'd like to be able to have the ability for our applicants to attach their resume as well as their cover letter, however once I add one field in a form, I'm unable to add the other. Has anyone had any…
-
Smartsheet support?
Can anyone tell me how to get support from Smartsheet? I've put in a ticket almost 2 weeks ago and have not heard a thing back yet. Thanks,
-
Report that features tomorrow as due date
Trying to create an automated report that pulls items from multiple sheets with a due date of tomorrow only. I have one that does the same for today, but tomorrow has proven to be more challenging. I could manually update the report every day by changing tomorrow's date, but I'm trying to avoid that. And using "is in the…
-
Sunday IT operations
Hello, I would like to know if there is a way to force a task to be planned a particular day of week (sunday in my case) ? Saturday and sunday are not working days but for special IT operations we need to work a day off. Thanks for your replies.
-
Help with update requests
Hi all, trying to get my head around automating update requests. I have a large sheet with many columns, each row is a record of an employee, most easily identified by the "email" column which is a type 'contact' and has their valid work email. It also tracks a multitude of events they attended, their reporting manager,…
