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 2016 Posts
Archives for April 2016
Discussion List
Counting Blank Cells
Is there a way to write a formula that will count the number of BLANK cells?
Clear Cells if Time Is
Hi, I'm looking for a formula to clear the contents of a column daily (preferably at a specfiic time). To give you an idea of what it is being used for; My sheet has a list of contacts and a yes or no checkbox column. Every day at a certain time an update request is sent out to all contacts listed asking "will you be…
Cell Linking with Auto-Numbered/System Created (Date)
Hi All, When cell linking an Auto-Numbered/System Created (Date), why does the time stamp section not link as well? For example; In one sheet i have an Auto-Numbered/System Created (Date) displaying [08/4/16 13:22] but in the linked cell it only shows [08/04/16] no timestamp is carried across. Where am i going wrong?…
Help with Duration by assigned to formula
I need to sum the duration colums by assigned to if the status is complete. I am having so many errors when trying to do this. Can anyone help?
Multiple account access - different companies
Have you foreseen including a muliple account feature? I value this product so much that I implemented it in another company. Having a multiple account feature makes it easier for me to switch back and forth between companies. Keep doing a great job, I´ve tried your new "sights", very good, I shall be adding to the…
Contact List - Assigned to - automatic alert?
Hi guys, Is there a way to automatically 'alert' someone if they are 'assigned to' a task using a contact list column? Would love to hear a workaround if you have found one. Cheers
Company administration level management of non-licensed users
We are using smartsheet to track staff resources across our projects, which only requires senior staff to be licensed users and collaborate, all other staff are listed as non-licensed users and won't ever need to use the sytstem. It would be easiest for us to have full control of their profiles as admins when they are…
How to combine different data from several sheets into word processor document?
How do you combine different types of data (different column headings) from several sheets into a single word processor document? I looked at the Google doc mailmerge, but it will only merge the data from a single sheet. I looked at reports but the mailmerge does not work with reports. I looked at linking the data to a…
Owner Task Counting and Reporting
How would I create a formula to calculate tasks complete (last 30,60,90 days), open, past due by owner similar to this screen shot which comes from the Webinar - "Manage and Track Tickets with Custom App".
Create report based on a conditional format in sheet
We are trying to build a report that looks at the format of a cell in the main sheet. We are using the conditional formatting option to set a specific cell's format based on the combination of various other fields in that row. Now that the sheet is correct, we are going to the report builder to create a report that looks…