-
IF AND date issue
Hello, I hope you can help please. We use Smartsheet to prioritise our workload. What we want to do is to highlight if a task is due this week but we have not manually indicated it as a priority for this week. I have written an IF AND to use a red indicator if the conditions above exist and green if not. It seems to work…
-
Embed an update request form on a dashboard?
Hi, I am using smartsheet to administer small grants and organise the adjudicators. The dashboard is great because I can include the adjudicating instructions in one widget so it's easy to refer to whilst judging. What I was wondering is if there is some way of embedding the update request form into a dashboard. I can send…
-
Scrolling with a mouse wheel
This is a minor thing but trying to figure out how to scroll up and down in my sheets using the wheel on my mouse. This works in every other piece of software I use but in a Smartsheet I have to use the slider bar on the side to move up and down through a sheet.
-
Podio and SmartSheet
Is there a way to push projects from SmartSheets to Podio?
-
Using COUNTIFs with FIND & AND
Hi, I need to add up the following: 1) All Labeled as Country X from a Qualitative field that is requiring me to use the FIND function. 2) All labeled as AreaY across 3 columns (I have tried selecting all columns as a range and also just selecting the relevant rows as well). Currently using: =COUNTIFS({Consultant…
-
Parent Date Roll ups - Possible for two sets of dates?
I have a head scratcher here, thanks in advance for any help that anyone may have. My scenario is this, I have project plans that have two sets of dates, one is estimated dates and the other is the actual dates on the project tasks. In my project settings the estimated dates are linked to the dependencies. When I enter in…
-
RYG Formula Average
Is there a way to take the average of the RYG colors and roll it up to an overall summary for a section and then the overall section to the overall project summary? I've included a snapshot of what I'm talking about.
-
Auto-populate a cell based on column dropdown
Hello, and many thanks in advance for your help. I'm new to Smartsheet and spent some time looking through the various answers on this community forum and could not figure out the answer to this question. I've attached a screenshot of a smartsheet I've made. I added a section at the bottom of my sheet called Reference. My…
-
Formula
I'm looking for a formula that would let me update the status column when the %Complete has a value entered. It should read if 0% is entered Status would be not started; if a value of 1-99% is entered then it is in "Progress" in the status column. If the % Complete value is 100% then the status column would show "Complete"…
-
Count Children in adjacent column
How do you write a formula to count certain values of an adjacent column from where you want to the count value displayed. In my sheet I need to count open positions and filled positions based on the status. My sheet is very large so I have to replicate this many times with varying row #s so looking for a quick way to tell…
