-
Creating a new Report based on a single Sheet
I create Reports frequently and am comfortable with the process. What I'm wondering is if there is an easy way to create a Report from within a Sheet that is based on that same Sheet? I guess I'm looking for an option in the File menu that says Create a Report from this Sheet vs. starting a new Report and then selecting…
-
Ensure a cell value is unique OR if already used, match the previously used value
I'm completely new to Smartsheet so I may be overcomplicating this, or going about it the wrong way. I want to ensure the value entered into a field is either unique within the column, or if it has been used before, then I want to to be exactly the same as a previously entered value. The use case is: I have a Smartsheet to…
-
Showing multiple true checkboxes as joined or concatenated text in another column
I have a volunteer submission form which has about 10 columns that exist as just checkboxes on/off - each of these relate to a conference work area and volunteers often select multiple. To easily view the data for a single person/row without tons of scrolling and looking up and down at column titles, I want to aggregate…
-
Financials: projected, actuals and variance
Hi! Very new to smartsheet and looking for any preset reports for tracking 3-4 year project financials, specifically projected spend, actuals, and variance. Does smartsheet have this type of reporting? Thanks!
-
Report with multiple tasks as ("what") conditions
How do I create a report with multiple tasks (in my primary column) as conditions? E.g. I wanted to display sheets in a report where Task 3 = Yes AND Task 5 = No.
-
Link comment
Bonjour à vous I would like to know if it is possible, to have a quick access of the good line in smarsheet when you link a colleague and you leave a comment with the @ and they open it in a email ? All the time when they open it, they are redirect in the master sheet... Merci
-
Cancel Scheduled Backup
Does anybody know how to cancel scheduled backups?
-
Building custom actions
I need to continue some training in setting up actions from one sheet to another. I can use the pro-desk to set up a 30 minute training session but can't remember how to get the code to type in for a new request. Thanks, Dennis
-
Adding virtual sticky notes
I have a sheet detailing meetings with dates, times and locations lined out. What is the easiest way to add a note to the overall sheet that shares info that applies to all events? I want to essentailly add a sticky note to post my list of items to bring to each event. Any ideas how to do something like this?
-
Scanning a Barcode
Does anyone currently know if smartsheet is capable of capturing data from a bar code?