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
Mark Complete If column value is 100%
Hi Everyone, I'm trying to write a formula to mark a status column one of the following based on a % complete column: Complete If 100% Not Started If 0% In Progress If 0<>100% Empty if blank I'm using: =IF([% Complete]1 = "100", "Complete", IF([% Complete]1 = "0", "Not Started", IF([% Complete]1 = "", "", "In Progress")))…
Formulas looking up data from other sheets
Is it possible to create a formula in one sheet that looks up info from another sheet? I dont mean linking cells - I need to be able to set an IF statement based on the input of one column in another sheet. You can do this in excel so im wondering if Smartsheet also allows for this.
Viewing Cell History of Linked-In Cell
Our users are wanting to see real cell history on a cell that is linked in from another sheet. If you right-click the cell, it shows the history, but the user is shown as "Cell Link User", which makes sense. When you double-click the cell, it opens a pop-up with the sheet/cell it is linked from. It is not possible to…
Cell Linking Limitation
I'm using cell linking for data flow through to help automate a workflow. The "Create Link" button is no longer available in the cell linking menu. I'm no where near the limitation of 5000 cell links for a destination sheet. Anyone else have this issue?
Setting up a recurring meeting notice
Can anyone tell me if it's possible to set-up a recurring weekly meeting within smartsheet for about 15 participants and include weekly agenda items? Thank you.
How to connection/Integration of Smartsheet with Outlook 2013 Desktop
Hi all, I'm looking for a clear tutorial or procedure to connect Smartsheet with Outlook 2013 Desktop. My Outlook is connected to an exchange server. I don't have any Office 365 login or paid account. I tried to install https://store.office.com/smartsheet-for-outlook-WA104379434.aspx?assetid=WA104379434# but a Microsoft…
Sights examples
I am just starting to look at using the Sights feature. I would like to hear what others in the community are doing for real life examples. Thanks for sharing!
Auto-save no worky?
I've set the auto-save to 3 min. of inactiity. But i get this prompt to save. Am I minstanding how this feature work?
Improvement for 'Send Update Request'
After sending an update request (for 1 row), the receipient receives an e-mail with: Subject = 'Update Request: 'description of Primary Column'. This works fine and provides good information for the receipient. :) After the row is updated with only a Discussion, the sender receives an e-mail with: Subject = 'Update…
Can you import Google Analytics Data to Smartsheet?
We need to get GA data in SS for multiple websites to run reports, We were wondering if there was a way to connect with GA like some of the visualization companies do.
