-
Smartsheet template with approval request
Hello, We will need to create multiple number of sheets periodically and thinking of creating them from a Template. The sheets will be quite basic/plain - mainly contain free text, drop down list, number and dates. I am quite sure this can be accommodated by the template. Can the template also cater for Approval requests?…
-
Profit Grid
Just wanted to share this. I figured out how to build an employee profit grid. We use forms to track tasks jobs & time spent on tasks. We're now able to pull this info into a report that calculates how much PROFIT the team member makes, or if they're costing us money!
-
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…
