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 September 2015
Discussion List
Issue: Being prompted to save changes when I've only viewed a sheet
Good morning, I don't know if this is a known issue or not. In Google Chrome I've had this happen several times. I've viewed a sheet to just look at the latest info and when I go click out of the sheet I am prompted to save my changes - but no changes have been made. I don't use other browsers, and it seems to be…
VLOOKUP Function
It seems like others have inquired about VLOOKUP. I'm sure this is in the works as part of "enhancement request". Is there a timeline when this will be released?
Creating a formula that relies on conditional formatting
Hello all. This may be out there, but I am not really sure what search words to use, so haven't had much luck in seeing if anyone else has come up with a solution. I am trying to create a formula that will calculate the sum of all cells in a column that meet a specific format, in this case, shading. I do not want to have…
"Saving as new" options doesn't roll forward alerts
I have several month-end sheets that I rollforward each month and the "save as new" option allows to keep data/formatting, attachments, discussions, and forms but not notifications/reminders. I have several alerts set up throughout multiple sheets. When I roll the sheets forward with "save as new" I have to then set up all…
can you use smart sheets for time tracking
We are looking at different CRM tools so that we can track time in a common place. Does smart sheets have the capability to do time sheet tracking?
Limited number of sheets
My 30 day free trial just expired and I upgraded my membership to basic so I could continue to develop some workspaces in smart sheets. I didn't realize with this membership I would be limited to only 10 sheets. I need to have a workspace for templates (up to 20) and then need to be able to manage each client within a…
Checkbox Checked depending on text
Should be simple, but I'm struggling. Two columns Text Column that contains some text. Checkbox Column I would like a folmula for the checkbox column to check the text column for some text. If the text column contains the text, mark the checkbox checked. Can this be done?
Count Past Due Tasks
Hi there - I'm new to formatting / formulas in smartsheet (and excel for that matter) and haven't had much luck creating a formula that counts tasks that are past due. While able to use conditional formatting to visually identify these items I'm trying to roll this up into a project overview; the overview/dashboard -…
Web Forms size of input boxes can they be changed
Hi I am looking for help can i change size of an input box ?
Hyperlink to Cell in same Sheet
How do I hyperlink a cell in the same Smartsheet?