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.
Discussion List
Can't get column data from more than 1 sheet
I am trying to prepare a report filtering information from 2 different sheets, and I need 2 columns from each sheet. When generating the report only data from one sheet is reflected in the report and the columns from other sheet are blank. What should I do.
Update requests with predecessors?
Hi all, I am trying to send out update requests with Smartsheet with tasks with a predecessor, but the other user is not able to make a change. I would have assumed that if someone needs to update the sheet, even with a predecessor on the task, this should show and allow for the change to be made? Any help is greatly…
Settings for Checkbox Column
How do you change the setting for the checkbox column? I want the whole task to be crossed out if the checkbox is checked as done. I copied this from an old Smartsheet account and that setting didn't carry over. Thank you!
Rolling up Conditional Formatting
Smartsheet Community, I have a normal project in which we have tasks that sometimes go past due. Currently I have conditional formatting set such that if the task is not 100%, and the due date is in the past, that whole task row turns red. My question is how do i get that past due task (red) to filter up and make the…
MS project?
Hi Can I export to MS project? I can't click the buttom
Can you vlook up two sheets?
I have related data on two seperate sheets. Like excel - I want to establish v look up for one sheet to update when other is updated with master information
Need Formula for Automating RYGG Balls
I need help writing a formula that will change the color of the health RYGG balls depending on how close to the end date we are. If end date is prior to TODAY, = Red If (Today-Start Date)/(End Date-Start Date) is greater than or equal to 50% = Yellow If (Today-Start Date)/(End Date-Start Date) is less than 50% = Green If…
Adding the business tools
Why couldn't I add business tools? Do we have to buy each? Or do I have to work with my administrator?
Viewing/Scrolling images
Viewing images as attachments is somewhat cumbersome at the moment. Currently, you have to click individual images/attachments to view them. A next button would be super cool. Is that anywhere on the horizon? I appreciate the help and feedback. Thanks, Preston
Auto-sorting Rows
My sheet is automatically sorting my rows without any sorting or filters applied. After I enter a new row at the bottom and hit Save, the row is displaced to another location within the sheet. I need to be able to clear this setting and get my sheet sorted the way it was before... with the newest entries at the bottom. Any…