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 2015 Posts
Archives for May 2015
Discussion List
Sharing Multiple Sheets
I want to send a link to a few people who are shared on multiple sheets. I tried following the steps in setting up a workspace but I can't find how to add several already created sheets. I don't want to send them individual emails for each sheet this will be too confusing for them.
Conditional formatting for checkboxes
Hi! I'm writing a smartsheet for basically keeping track of a checklist - I was wondering how to write the nested conditional formatting (like for Harvey Balls) but with a checklist. So if rows 4-7 in the "Complete" column are all ticked then the box in row 3 will be ticked. I'm happy with the formula needed but don't know…
Is it possible to create a web form with appointment time bookings?
Hello, We're looking to run an event where people can meet 1:1 with an onsite consultant but want people to book a time. Does SmartSheet allow the creation of a web form where people can select from a time slot and then it no longer become available for anyone else? Thanks, Julie
Formula headache - Do not show SUM result if a cell in this SUM is left empty -
For an event budget I've added a column invoice. The SUM =SUM([Subtot inc BTW]8 - Factuur8) compares the quotation with the invoice However I'd like to find a way that the column only shows the result of the SUM after an invoice ammount is typed in. Since a lot of cells are left blank in the column invoice the above SUM…
Search the current report?
I know there is a way to constrain a search to the "current sheet". Is there a way to constrain a search to the current *report*. Thanks, Stan
Hours tracking conundrum
Hello, I'm a new user who has completed my 1 month trial and had a 30 min session with a SS expert. However, I still haven't figured out how to make SS do what I want it to do. Specifically- I work for an 8 person consulting firm with an average of 70 clients at any given time. Sometimes one consultant works with one…
cell linking
Is there anyway to cell link in templates? or Template to sheet? or just sheet to sheet? trying to keep annual running records for monthly reports?
Column Formatting of Zip Codes, Phone Numbers
I'd like to be able to choose a preformatted Zip Code column type, as well as a preformatted phone number column type. Currently, any Zip Codes that start with "0" (as in, the entire New England region) get messed up in that column - because "zero" isn't recognized as an initial number (so - it wouldn't have to be a zip…
Different working days per task
New smartsheet user here. I really like it! However, I need a way to change working days on a task level. Is this possible? For example, I have "cure time" for concrete finish work. The time is continuous regardless of holidays and non-working days. The concrete just sits and cures. Nothing else needs to happen.…
Recurring Reminders
Team, Is there any way to set up recurring reminders on individual tasks? Thanks you!