-
How do i highlight a cell to be red/green based on the 2 date columns I have?
I have about 10 columns of different Plan and Actual due dates . I am trying to get the the Actual Column date to highlight in green when it is before or equivalent to the Planned date. How do I do this? in the conditional formatting i'm limited based on the calendar, when it's actually based on the input for the planned…
-
Project Resource View - Hours
Hi, I am managing a project right now, and I want to see to how many hours per resource each time I assigned a tasks. The project that I am managing will run in 1 year so I want to capture and see like how many hours they spent to date. In my sheet, I have an 'actual hours' column and 'assigned to' column (This is multiple…
-
New user access in dynamic view
hi , In my current project, some of end users are not added in non licences smartsheet account(organization account) but i will share dynamic view access to the users using view settings.. when i share dynamic view, users 1st sign up and then login smartsheet account.. so my question is to access dynamic view, users must…
-
Count Function not working
Hello, I am using a COUNTIF function as shown in the screenshot attached, and it is grabbing the "Complete - Handover to VAR" Status field, but not the "ONB - No Reply by VAR" status field. There is some conditional formatting applied, but I'm not sure what the formulae isn't calculating the ONB - No Reply by VAR field.…
-
Move Row w/ Formulas
I have 3 sheets that are being used in tandem: Sheet 1 Registration Data Sheet 2 Travel Requests Sheet 3 Cancelled Registrations Sheet #1 has a "registration status" field (dropdown). This field is being pulled into Sheet #2 by using an Index/Match formula. If the registration status (on sheet 1) changes to cancelled, I…
-
Moving rows to new sheet with proofing enabled
It is very inconvenient that I am unable to move rows that have proofing enabled to a new sheet (keeping the proofs intact in the new sheet). We have purchased a new company and we need to move those company-specific rows to a new SmartSheet (including the proofs) but we are unable to do so. Is there a work-around solution…
-
Form Dropdown Help
I am trying to create a form where every student is scored under the same category all at once. For instance, I have 15 students; all 15 students will be scored on 12 categories each day, with a possible score of 1-5 for each student on each category (all numbers don't have to be used, but they can be). I want the form to…
-
Updating (e.g. formatting) Sheets - Is there a better way?
Good Afternoon! I am 2 months new to Smartsheet and enjoying the journey thus far. Project Background: I am working on developing a "master template" of tracking Objectives & Key Results (OKRs). In doing so, using the Master template which contains alot of formulas and conditional formatting, etc. Once I get it designed as…
-
Smartsheet Design to Auto-update all sheets based on a master sheet or template?
Good Afternoon! I am 2 months new to Smartsheet and enjoying the journey thus far. Project Background: I am working on developing a "master template" of tracking Objectives & Key Results (OKRs). In doing so, using the Master template which contains alot of formulas and conditional formatting, etc. Once I get it designed as…
-
Type in Korean in comment box problem
Hi Smartsheet! Type Korean characters in comment box is not working on Windows 7. Tested with IE and Chrome, both the same. Any one has any solution? Thank you.