-
Dashboard Permissions to Report/Data
I have created a dashboard for our creative team that is set up so that only the person viewing the dashboard can see their metrics. That being said, I found out the hard way that they cannot see their data unless I share them out to the metrics sheet and the metrics report. Is there any way to avoid this? I don't…
-
SUMIF(OR(???
I am trying to sum a column if either my Paid in 1st half in 2019 column is checked or my Paid in 2nd half in 2019 column is checked. I am trying to use a few different formulas without success. Here are a two that I've tried: =SUMIF(OR([Paid 1st half in 2019]:[Paid 1st half in 2019], [Paid 2nd half in 2019]:[Paid 2nd half…
-
Dynamic SmartSheets an Option?
First-time poster and amateur SmartSheet user here. I have an existing Excel spreadsheet for our association's Marketing Schedule. Each month has a row and each marketing medium (newsletter, magazine, social media, online ad, etc.) has a column where I list all of the programs and services that will be featured in that…
-
Set up Review Request button grayed out in proofing
I'm giving the new proofing tool a try, and am stuck. I've enabled proofing on a sheet that I created in a workspace with numerous users with different levels of permissions, and have uploaded and made a couple pinned notations on an image (I have not yet @mentioned anyone). However, the button for Set up Review Request is…
-
Conditional Formatting For Date Cell
Hi, I want to apply conditional formatting to a date cell if the date in that cell is earlier or later than a date in another cell. Can someone tell me if this is possible and if so how to do it? Thanks. -Marcia
-
Request update only if no recent update exists?
Am I being dense? I can see ways to automate a reminder based on conditions, but in a sheet with multiple submissions from one person, if I want to remind them ONLY if I haven’t received a recent update, I can’t say “don’t send if.” ? I can send a request for update based on “if not in the past” but if there is a recent…
-
Priorities within Priority
I have my priorities set up for high, medium, low. I'd like to prioritize within the highs, lows, etc. I'm used to working of an ABC, 123 set up.
-
If with dropdown list
I'm trying to come up with the formula to dropdown only certain countries if chose certain region. I have two dropdown columns Region and Country If chose Region EMEA, country dropdown list will show DE, DK, NO If chose Region APAC, country dropdown list will show JP, SG, IN If chose Region AMER, country dropdown list will…
-
Dynamically Add columns
Hello, I have a form that was created that we send to a group of individuals asking them to update the status. Currently, the form is formatted as a text box where we are the individual to format the date and add a comment. As you can imagine this doesn't allow for the best reporting. I am curious is there a way to create…
-
Free Collaborator / Unlicensed User
Hi, Just a small question is the Unlicensed User can also delete the row? Scenario: we have created a workspace and we want Unlicensed User to only edit the row but he/she can't delete the row. secondly: if Unlicensed User delete row or related information in row how the admin will get to know what happend or what is…
