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
IF Formula Help
I'm terrible with formulas! What would my formula look like to do the following: I have a listing of open action items, each with an attached target due date. I need the RYG overall project status balls to update automatically. Green if no action items are past due, according to the target date column. Yellow if one action…
Kanban Board by Team Member
We're using the card view for a company Kanban board. However, we also want each team member to have a personal Kanban board that just tracks the projects they're assigned to. Right now we're linking cells to a separate sheet for each person which is time consuming and needs to be manually updated every time a new card is…
Individual Days Off
Is there a way that I can schedule individual days off and have them reflected in my Gantt charts? I know the options are available for across the board, but what about individual vacation days. Thanks!
Advice on Simplifying formulas
https://app.smartsheet.com/b/publish?EQBCT=3ae72b85648c4e968b5320160bb7e3c6 This sheet checks the net time machines were down, or work was done on a line item by using a date modified column and a date created column. The formula is rather complex, and I am not going to have the time to teach anyone how to edit it (they…
Can you update a current Smartsheet with an MS Project file?
Good Afternoon Smartsheet Community, I have a vendor who provides me with an updated MS Project file on a weekly basis. Is there a way that I can upload the updated file to the Smartsheet I created from the original plan? I would rather update the current plan than delete the old one and upload a new one. Thank you. -Jerry
Is there a way of allowing Editors the capability to Sort Rows?
I have a Current User report available consolidating many projects into one so it doesn't become overwhelming to the users. But it seems they have no way of Sorting is there an option for this? Other then Admin doing this?
Issues with Form display in IE
Hi all, I am facing issues with the form elements display in IE. None of the checkboxes are visible in IE whereas they work perfectly fine in Chrome and Firefox. I am using "CAption to the right"display type for check boxes. Is this a known issue? Thanks Pallavi
Smartsheet Sorting
Hi, Is it possible to sort data without having it sort the first two rows of data because the first two rows of data are my column titles. My column titles are just repeats of the smartsheet column titles. Thanks! Kevin Au
Month/Year to text
I am trying to extract the month and year out of a date column and join them to create a unique key. For example the value in the date column is 8/18/2017 I need a formula to return 82017 I can extract the month and the year without a problem, but when I try to combine them I get the sum of 8 and 2017.
Continuous Links between Sheets
I have a master (parent) sheet linked out to several child sheets, the master effectively pushes header information out to the child sheets. When a new row is added to the master, the child sheets fire off a notification to various teams requesting their input. This may not be the most efficient setup but it currently does…
