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 February 2017
Discussion List
500 rows per page in reports - Calendar View
Looking back, it appears the maximum number of rows per page was increased from 100 to 500 in order to have fewer customers using Calendar view encounter paging. Seen here: https://community.smartsheet.com/discussion/reports-now-have-500-rows-instead-previous-100 Well, as our company leans more on Smartsheet, I suppose we…
Auto Fill Dates
I am trying to have cell automatically fill the following dates: * First day of the current week (i.e Monday) * Last day of the current week (i.e Sunday) * * First day of the next week (i.e Monday) * Last day of the next week (i.e Sunday) * * First day of the previous week (i.e Monday) * Last day of the previous week (i.e…
Automatically add rows when report refreshes
I have a report that's running every day against a single parent row to grab totals. A few cells of that one, single, lonely row. I'm looking for a way to automatically copy the report's information into another sheet daily, that way, over a period of 1 week, 1 month, etc., we can see the changes in the totals. This is…
Can you add an item in calendar view?
Can you add items in calendar view, or only edit?
SUMIF (Final piece of the puzzle)
The sale been made and fits the criteria (Sold By) Peter, (Status) WON, (Result) 100%, (Current Month Sales) this month/yer date, it returns dollar value. The job has been invoiced, (Invoiced Date) todays date 25/02/17 (Nz Time) returns (Comms Due Date) 20th of the following month, in this case 20/03/17. So when (Current…
Can you make columns visible to certain viewers only
I have a smartsheet sharing with my customers and I would likeuse the modified by column for my reference but I do not want my customers to see that. They are shared as viewers only. Thanks Howard
Fields in Calendar view or dates in card view
I need to be able to print a weekly calendar of the tasks I am assigned to (task name is primary field) and the number of hours each task will take. I have tried doing that in the calendar view but will only show one column field. I also tried doing it in the card view but that won't let me use the date as a Lane. This is…
Autofill compliance
User Mgmt: I have users entering data into a sheet. They are not always inserting lines in a manner consistient with Autofill and some formulas in hidden columns are not filling in, "breaking" the sheet. Does anyone have any strategies for making sure people follow rules that allow autofill to complete? I have trained ad…
Compare two dates and apply conditional formatting
I have two columns of forecasted dates UTILITY and IN SERVICE. When the UTILITY date is past the IN SERVICE date I want both cells hilighted. For example if UTILITY = 9/30/17 and IN SERVICE = 5/10/17, I want both cells to be red. I understand That I'll have to use a third column to base the formatting from but I cannot get…
Need a way to calculate hours and minutes
We are using the hours and minutes duration option for our projects and need a way to calculate the stop time based on the duration. We enter the duration and Start Time and want Smartsheet to calculate the stop time (currently we have to enter it manually and there is definitely margin for error... not to mention time…