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.
Discussion List
Printing info
Is there a way to print a list of all the people that I have shared a sheet with?
Formula -
Trying to wrap my ahead around a formula to accomplish determining the top 5 $value projects in a list. I know in excel I could use the LARGE formula to accomplish this...how could I do something similar in Smartsheet? Thanks community!
Formula needed
Happy Thursday, all! I have a sheet with invoice dollar amounts in several cells.('Amount') Next to these cells, I have a checkbox column called 'Paid' that is checked on if the invoice was paid, checked off if the invoice was not paid. I need to total all invoice amount cells for invoices that are paid. Any tips on the…
Opening emails attached to smartsheet from Iphone
When I attempt to open an email that is attached to smartsheet with the Iphone app I only get a screen that has the file name and size. They open fine from the computer?
Conditions of filtered view
It would be very useful to be able to have variable conditions for filtered views. So when defining what you want to view, each criterion has the option of being a "must meet" condition or "desired" rather than all criteria being one or the other. Like a and/or option per criterion.
Conditional Formulas
Hi, I'm working on a sheet and I'm trying to have a row be highlighted if it is before or after a set date but I can't seem to figure out the formula for that. My sheet is set up so that I have a column for the start date, a column for the end date, a column for the actual date it was completed, and a column that I will…
Children and Sub Children
Hello, I need a little help with formulas. I want the parent to count the children and the sub children separately. Example below. I was able get the parent to count the children but when I try to count the sub children separately it counts all the children. This is the formula I used to count the children =("CONTRACT NAME…
Autofill - Formulas referencing above cell
Hi, I have one column creating a reference numbers for a hierarchy from three hidden columns similar to those using a format of 1.1.01. My Level 2 and 3 formulas are as follows =IF(COUNT(ANCESTORS()) = 0, <ABOVE CELL> + 1, <ABOVE CELL>) Number increases with each row, except where it is 2 or more layers in, in which case…
Printing from Sights
Hi, I'd be grateful for any advice on printing from Sights. Is there any way to print or pdf onto more than one page, otherwise my Dashboard comes out way too small. Thank you Tim.
Due date PRIOR to weekend or holiday
I have a one date upon which all other due dates are calculated. We have holidays set up for the account. I need the due dates to fall on the weekday PRIOR to the due date if it is a weekend or holiday. It appears the Workday and Networkday functions fall on the following week day, which doesn't work for me. This formula…
