-
Sharing Sheets to Multiple Workspaces
I was wondering if I could have a sheet be located in multiple workspaces simultaneously. For example If I wanted to have individual workspaces for each project I am working on, but also have separate workspaces that would allow me to see overviews for ALL projects, all pulling from the same sheets.
-
Form function for SmartSheet
Hi, I have smartsheet to record each building general meeting info, such as building manager, meeting date, building name. In each meeting, we need to prepare meeting supplies (there are around 30 items, such as pen, projector, binder..). I would like to use smartsheet "Form function". Then link is created and I can send…
-
Search through Symbol Column
Hello, I am trying a formula to search through my Symbol Column and get back a Symbol, if there is the same Symbol in the Colums: I am now trying with: =IF([Eskalation]:[Eskalation] = "Extreme"; "Extreme"; "no Extremes") it shows me that the formula is wrong. Anyone has any idea why? I just want to have a Cell at top, that…
-
Column heading on Smart sheet Card
Hi guys Short and sweet. I've been using Smartsheet to provide a rating for the team (example below and attached) Basically, what I would like is to show the actual column header name in front of the Stars symbols. At the moment we know what they are based on knowing the sheet but to a new user they need to keep going to…
-
can we create a form publishing a table ?
can we add a table ( instead of single questions ) to a input form ? we need external users to post a list of items with some attributes , cost etc .. list has variable size I cannot handle this with single input fields
-
Add a row to an existing update request
Is it possible to add a row to an existing update request. I have a sheet that allows users to select an update frequency (i.e weekly, monthly & quarterly) for their initiative via the webform they use to load the initiative. What I would like to achieve is to set up an update request for each owner (weekly, monthly and…
-
Automate from Google Form to SmartSheet to 2 Documents?
Is it possible to auto generate 2 documents from within Smartsheet when ever a new response comes in? Client fills out Google Form Response is stored within SmartSheet automatcially 2 Google Docs are generated and place in two different Drive folders Possible?
-
IF formula with dates
Hi Can anyone assist with why this formula doesn't work? Ideally I would like to return a text result of "FY18" if the dates are in the range 01/07/17 to 30/6/18. Thanks in advance. Richaerd
-
formula to distinguish decimal versus percentage (i.e. 1 versus 100%)
I have a report that combines many sheets. Sometimes the values entered as 1 rather than 100% (or .75 rather than 75%). The report is an input into Tempus (Smartsheet partner) and it makes a difference to their application. Is there a way to determine that a value is NOT a percentage? Or require entry of a percentage, or…
-
New! Row Edit Multi-Pane View - will this help your SmartSheet efficiency?
Hi, why always separately open the multiple edit dialogue boxes for data linked to a row -when you could have one click optionally open all all simultaneously in a Multi-Pane popup window! - Row Edit, Discussions, Sharing, Attachments, (PLUS even a new feature - part of the multi-pane window showing an email thread linked…