Product questions?
Ask it here! The community's got your back.

Smartsheet Basics

Ask questions about the core Smartsheet application: Sheets, Forms, Reports, Dashboards, and more.

VLOOKUP for highest value
Can someone show me how to use a VLOOKUP for the highest value? For example: =VLOOKUP(LARGE([% of Target]1:[% of Target]16, 3), Name1:[% of Target]16, 2) Basically by the LARGE([% of Target]1:[% of Target]16, 3) I am returning a value of 52% (which is the third highest value). This is automatic. =LARGE([% of Target]1:[% of…
New Formulas
It seems there was recently an update that included a large number of new formulas. Does anyone have the comprehensive list? Any special notes about individual ones?
Using If AND FIND formulas together
I am trying to use if and find formula to look some letters in strings at the different cells. And if they match with each other I want to give output as "TRUE" and they don't I want to say "False". For example I am looking $ sign in different rows and if they match I want to have output as "TRUE" and If they don't…
change entire background of card view?
Is there a way to change the background of the overall board in card view? Not the cards themselves, but the default gray background, can we change that? I haven't found it if we can.
Send Weekly Request to Complete Survey
I am interested in sending each of my team members a weekly Temperature Check survey. I created a new sheet to collect their responses, and a form with the questions. I believe i have an automated workflow set up so that an alert is sent to each team member every week at 2:00 pm on Fridays. In the Message, I included a…
Editing RTF widget content, help!
I really find the editing in the RTF widget frustrating, what's the secret? Backspace doesn't delete, I cant select/remove spaces, lots of random behavior How do I remove the spaces highlighted in the screenshot? (I want it to behave just like the RTF editor I'm using to compose this message!) Darrell
Resource Viewing in Calendar View
Good afternoon We have resources that we have assigned to tasks for the next few months, booked out. How are we able to see our resources in calendar view?
Trial emails
Hello, I'm a licensed user to Smartsheet and if I share my sheets with other users in the organisation, they have to sign up to view them. That's fine, except they're then bombarded with trial emails (You have a 30 day trial, upgrade now! etc.). I don't want them to be a licensed user, I just want them to collaborate on my…
ABout Cell Linking
How can we automatically update our columns when it is linked to another columns? I do not want to use copy and paste because I want the range of columns to be unlimited? I am getting update from web forms on my main smartsheet but I want to update that data on my other smartsheet as well? How can I do that?
Anyone else experiencing an issue with Card view details?
Steps to reproduce: 1 - Change a sheet to "Card view" 2 - Open one of the cards to view the details 3 - Scroll down to a field and click inside the cell 4 - Does the details window anchor back to the top thus not allowing you to click in the details field? If so, I logged a request for this just now: 03425917 I had an…

Popular Tags

Trending in Smartsheet Basics

Adding a row via a Report
Hi, can you add a row through a report? If not, does anyone have a workaround, rather than creating the rows directly in the source sheet? Thanks.
Form Users Being Required to Sign In
Hello, I have a form that's set so that anyone with the link can use it. However, some users are being required to sign in. Does anyone know what could be causing this?
Audit trail for sent emails from Smartsheet
Is there any way to see an audit trail of emails sent from Smartsheet? Emails sent via an automated workflow or from a project manager sending the email using the "File >Send as Attachment" or "File> Email shared users". I would like to track the email that was sent, the date and to who it was sent. This would cover…

Help shape the future of Smartsheet.
Share your ideas and feature requests.

Watch video

Smartsheet Basics

Discussion List

Categories

Popular Tags