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 2015 Posts
Archives for September 2015
Discussion List
Printing without column headings
Does anyone have a workaround for printing without column heaings? I need to create documents that have a spicific look. i can almost get the documents to an acceptable level, however, when I print them, the column headings are printed. But in a few sheets these headings are irrelevant to the information in the sheet.…
Filtering defeats sort function. Moving row to another sheet drops attachment link and forrmulas
1. I use filtering to hide rows with status <complete>, however when the filter is set, the sorting function is defeated. To resort, I remove the filter, sort and then reapply the filter. This is awkward and wastes a lot of keystrokes if done 20x per day. Another bright idea was to archive the rows to another sheet titled…
Formula Returning Today's Date IF Column is Value
Possibly a dumb question... I am trying to format a date cell to return todays date if a cell in the same row is marked "Completed" using the IF formula. I am using the TODAY() formula as a result in the IF string, however it looks like the today formula cannot not work in this way: =IF(Status111 = "Completed", "TODAY()",…
Making % Complete Column Accurately Reflect Work Done
Hello, I am looking for a way to make the % complete on my parent rows reflect only work that takes effort, rather than processes that are just elapsed time. For background, my group uses smartsheet for project management purposes, but we also use it for billing. Our parent rows in our project sheets are all billing…
Reports not updating
I have a main sheet with many reports pulling from it. All was fine until about an hour ago. No matter what I do I can not get the reports to update. All the criteria is correct. Help....
Reports
I've created a report to pull data into a smartsheet based on a checkbox field. The field is called Dashboard and the report criteria searches all smartsheets and work spaces looking for this field and if it's checked it pulls data into the report. There is one smartsheet that has items that have no check in this field…
Remove the Logo From Your Account
I was trying to figure out a way to remove the logo from my Smartsheet, account. I did not want the default logo, and I did not want to use my company logo, since there is no way to control the location of the logo. There may be a better way to do this, but here is what i did: * 1) On the Account dropdown menu, go to…
Advanced Date functions
Anyone know whether I can use functions to add a number of months to a date so eg =Today +5 months
Can we set up our smartsheet to send email alerts to the team when a task has been completed?
We are a remote team and would like to set up alerts to notify the team wen tasks have been completed, is there any way of setting this up in smartsheet please?
Attachments
Can you drop and drag attachments between sheets?