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 August 2017
Discussion List
SUMIFS - Criteria person's Name & Date to SUM 3rd column with numerical value.
Purpose: To sum the hours worked per person for a given week. COLUMN 1: Name COLUMN 2: Date COLUMN 3: Hours (Integer Format) 2 independent SUMIF formulas working, but not SUMIFS together. FORMULA 1: =SUMIF(Name:Name; "Sid Organe"; [Tsk-Hrs]:[Tsk-Hrs]) Working FORMULA 2: =SUMIF(Date16:Date46; IFERROR(WEEKNUMBER(@cell); 0) =…
Column Visibility Restriction or Accessibility
My sheet got 10 columns and is shared to 8 people. 8 of the columns are name of the person I shared the sheet with. Is it possible that person 1 can only view and edit the column assigned to his name? If it is can you teach me how? Thanks!
Remove Parent data automation when Child dates are entered
Hi all, When using date columns, Start/End the Parent row auto-updates with the earliest and latest of its Child rows. Is there any way to turn off this function? Thanks, Josh
Enhancement Request: Auto-Refresh Functionality
I would like to request the addition of an auto-refresh feature within Smartsheet. I use one worksheet most of the day and I have to manually refresh the worklist several times each hour. It would be great if the auto-refresh feature could trigger anytime someone performed a change but I would settle for an auto-refresh…
Update Request for Specific User
I have a large project sheet with multiple people assigned to various tasks. I want to send out a weekly update request, but don't want to have to select each row for each different user, as these change as a project moves along. I have several people outside my organization where update requests work perfect for them…
Rounding
Hi, maybe a simple one: when I enter "0.00000872" into a cell - smartsheet displays 0.00001? How do I get it to display the actual value instead of the rounded value? Thx
API programmer in Copenhagen?
University of Copenhagen - Panum - is looking for an API programmer consultant for visualisation of our building maintenance projects. Please contact us in case of interrest.
Formula to Calculate all screening dates in last 7 days and last 30 days.
I am seeking a formula that will calculate all dates that occurred within the last 7 and 30 days...based on the "Screening Date" column...and should not include weekends if possible. Thank you
2016 Calendar By Day
Hi, I am trying to reconstruct a legal time line for 2016. I see have my option for 2017 and 2018 does anyone know how to do this. Thanks,
Change primary email
Does anyone know how to change the primary email?