-
Using formula =MAX(children())
Dears: I'm talking about one Date formated column. When my Parent cell has that formula and I have 4 children's (2 filled and 2 unfilled) the formula returns the MAX value between the 2 filled cells. I want for my Parent the MAX from all four childrens. I need to return the MAX value only when the 4 childrens are filled.…
-
Advanced User Training
Does anyone know if Smartsheet has ever had (or is planning) advanced user training available, similar to the Smartsheet Academy you can attend in person? or a User's Conference? It would be much easier to sit in a room with other advanced users and share ideas in person vs. on the web.
-
Card View Vertical Drag changes value
I love the new card view but in each vertical lane I'd like it to organize by the priority value. It would be great to have it automatically set the priority 1 higher than the card I just drug it above. And it would be great if it put it in order of the Priority Field if I edit them directly.
-
IT Employee Change Documentation
Good morning everyone, I'm exploring new options to replace out existing, out-dated InfoPath form for employee IT changes in our organization. Right now we get an XML file sent to our helpdesk, financial staff, and office services, so we'd like to be to emulate that functionality, just with a better output file that our…
-
Auto-numbering not working anymore!
Hi, With the new update, the auto-numbering doesn't work anymore. I get the same numbers everytime with a new row. Please help!
-
Sights Sheet Data Widget updating question
I am looking for a way within the Sights, Sheet Data widget to update the selected cells as rows are added to the source sheet. Do we know of a way to accomplish this? Any suggestions would be appreciated. Thanks, Bill
-
#INVALID OPERATION
Guys, Something went wrong with the latest upgrade, I have too many spreadsheets to fix, this formula now give a #INVALID OPERATION error, this is one of my formulas: =IF(ISBLANK([Paid Date]5), [Due Date]5 - TODAY(), [Due Date]5 - [Paid Date]5) Please can this be resolved.
-
Excel spreadsheet with calendar and schedule
Good afternoon, I hope someone could please give me some ideas if it's at all possible to do with smartsheet or in excel??? I have an excel spreadsheet that was created by a professional. I'll try to explain the information it has on it and what I'd like to do with it. It has the date, Hebrew date, and then in in many…
-
Shortcut link
Looking to create a summary smartsheet that has a list of sheet names in column A and shortcut links in column B. I know you can link cells within a sheet but i the desire is to link the entire sheet.
-
External clients access to view worksheets
I have created a project program which our client was able to view, however she now needs a"Log-on" & Password to be able to view my sheet. I haven't changed any settings, so I need help to let her view the project program?