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 January 2017
Discussion List
Project sheet start/finish dates
Hi all, Pretty much all my projects work over weekends. I am trying to set deadlines for start or finishes that land on either a Saturday or a Sunday, however, the project template keeps defaulting the dates back to the Friday. Any suggestions? Cheers
Filters BY Statues
Hi I was Trying to set up a sheet Filter to be filtered By Active Statues only I was doing though Symbols What is the best way ti filter A sheet with on Going vendors to see only Active vendors of that Period ?
Basing a count formula off of the current date for the day
I am trying to create a formula where I can total up certain fields each day. Does anyone know of the formula that would allow the use of today's date in a countifs situation?
I just Cant Seem to figure this one out help please.
Ok In the picture Below Cell ?:? is going to be a drop Down List pulled from a drop down list on a web site. Action wanted : * After I figure out how to link the Drop Down List in F20. * I would like to create a new Row above row 26 and Insert the Drop Down List Slection into B25 instead of in F20. * * Cells…
Send Update Request via API to Contact List User
Has anybody deveoped a solution using the API's to send Update Request from a sheet? Meeting with my developer to see if we can send an update request when the PAYMENT field changes to PAID status and the DATE PAYMENT RECEIVED is blank. Then send an Update Request to the User in the Agency Contact field which will be setup…
Google Mail
Does anyone know if there is a way to intergrate Gmail with Smartsheets just like they the Outlook intergation? I want to be able to put an email discussion and/or the attachements directly into a row of a sheet plus add the email topic as an action item.
Bringing an already setup group into my enterprise
Before we purchased SmartSheets Enterprise we had 2 groups each using their own smartsheetss setup. However now that we have purchased the Enterprise edition 2 months back we would like to bring the small group into an already estabilished enterprise without losing permissions. I know i can import peoples sheets one by one…
Create double entries without overwriting data
I have created a new smartsheet document (Simple Excel like doc) for my team members for data entries. We have noticed that if 2 of them are enteringdata on the same row and at the same time, instead of creating 2 entries, the system overwrites the original entry. Is there a way to stop this from happenning. This becomes a…
Permissions !!
I am currently using (KANBAN Sheet) to distribute tasks to my team. the problem is anyone from my team who has permission to (Edit cannot share) can drag and drop any tasks that are not assigned to them. thats make the board not under control by the admin, is there any solution that make the Admin apply restrictions to the…
Using a homeless "By Name List" and setting proper permissions
I work for United Way and we are currently incharge of managing our communities homeless "By Name Lists". In a nutshell, these are lists of current homeless people in our community, and is a way for agencies that provide housing to work together in helping people get housed. Also, because we're a non-profit, we only have…