-
Move row - selected columns only?
Hi, We manage Intake to Archive in Smartsheet. Our Intake Sheet (source sheet), where we collect all project info, is rather lengthy. When an Intake Request has been approved, I want the row to be moved to an Implementation Sheet (destination sheet). The destination has different columns that the source sheet, only a few…
-
Alert with multiple dates
Hello, is it possible to alert someone multiple days within a project duration? Example: Projects have a duration of 3 months. Within those 3 months, I need to reminder alert every 21 days. Please assist. Thank you, Grace
-
SUMIF with multiple columns
This should be simple but I appear to be going wrong somewhere. I have the following working for two columns =SUMIF([Loan Manager]:[Loan Manager], "GE", [Loan Amount]:[Loan Amount]) When I try to add another look up column it doesn't work, as below =SUMIF([Loan Manager]:[Loan Manager], "GE" , [Loan Status]:[Loan Status],…
-
email address change
Hi - my company recently changed all of our email addresses. Is there an EASY way to change this through to our sheets - we have thousands of lines assigned and cannot figure out how to do this. When a user adds the new email to their account, and makes it the primary email, it does not carry through to individual sheets -…
-
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
Is there a way to use conditional Formatting in a row and not just a column? As you can see in the attached photo I have different Benchmark numbers set up per row, If I set up conditional formatting it only lets me set up one value for my sheet if that makes since!???
-
Change color for contact list?
Is there a way to change the color of the circle with the contact's initial? We have someone on the team with strong preference for a color... Thank you!
-
COUNTIFS formula with multiple criteria
Hello, I've been having trouble with a formula to find out if new instructors (I also have returning instructors on the spreadsheet) attended a conference. Here are the details. I want to count column 6 "attended conference" when checked, only if column 3 "new instructor" is also checked. I've tried several variations but…
-
Nested IF
I cannot figure out why this formula does not work. HELP! Thanks. Suggestions: =IF([Complete]1 = 1, "B"), IF([Finish]1< TODAY, "R"), IF([Finish]1 >= TODAY(+45), "Y"), IF([Finish]1 <= TODAY(+90), "G", " ")))
-
Resource Views by Project
I am having numerous challenges with the Resource Views and not finding them particularly useful. I only want to see resources for particular sheets, my preference would be to select a workspace that contains all the sheets but as this is not available I am selecting all the sheets individually, however, I am still getting…
