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 2017 Posts
Archives for March 2017
Discussion List
Client Facing Project Management [help!]
Hello, I am trying to create a client facing project management report so that my clients know where they are at in the process. My issue is that to create this report I seem to have to give the client access to my internal teams project management sheet which means that the client can see everything going on on in the…
Help needed regarding Date formulas/Formatting
I have a question regarding DATE formula, I have two Columns 1st one "Project Return" and 2nd one "Revised Project Due", is there a way that i manually put a date in first column and the 2nd column automatically calculates a date 7 days later (working)?
Filter based update requests
Hello dear Smartsheet staff, I noticed discussions about update requests, some concern single or multiple rows, others concern columns or the whole sheet. Could it be possible to implement FILTER-BASED update requests? I guess that would satisfy everybody's needs. Best,
Dropdown list creation from existing columns
I have a database of our company standard operating procedures and I would like to have a webform which allows all of our staff to recommend a revision to a specific SOP. I think I would like to create a dropdown list from an existing column, but it looks like I'd have to type them all in individually to create the list.…
Auto generating items onto a separate sheet
Currently, my team is tracking roughly 60 projects (each one having their own Project Management sheet with dates assigned to individual items). I am using the RYG balls to track item status in each sheet but am looking for a way that I can formulate a list of items just in red/yellow across multiple sheets and combine it…
Full Version
Hi As a compnay (Connect 4) we are using the trial version but are very interested in upgrading to the full version, we would like to discuss what the software can deliver and potential training options. Please could someong contact me via phone or email to discuss, 01279401883 / james@connect4recruitment.com Many thanks,…
Implementing multiple dates in annual plan
Hello, My company is considering Smartsheet so I signed up for a free trial to just try out implementing our Annual plan, we have it in excel today. But am having a hard time adding multiple dates to each row, where each row is a persons annual plan and shows an overview over important weeks through the year. Se screenshot…
Could somebody please help with formulas and reports
I have created an action date column on all my spreadsheets, I would like this populated by default with today's date. I would then like a report running in the background letting me know if any lines become overdue i.e. in the past - I plan to display this on a large computer screen visible by all users If anyone can…
Working Days - Length of Day
Hi Team I have an employee who works 8hr days Mon to Thurs. 4hrs on Fridays. IS there a way in Project Settings Working Days to change the hours for a given day Thanks in advance