-
VLOOKUP Formula for Dashboard Updates
Hi there, I have a dashboard widget and I'd like it to automatically update every time a row of data is added to the a SmartSheet (see attached screenshot). I'm trying to use a VLOOKUP formula on the top row to always pull the latest data, but it's not working. Any formula wizards out there that can help? Thanks! Susan
-
Formula for Text
Can I use a formula to capture text from the cells below it. For example, if I have "IT-1900" in row 2 and "IT-1901" in row 3, can my summary row show "IT-1900, IT-1901"?
-
conditional formatting using two date columns
Hi, I use several date columns to track my project, for example, a start date, a finish date and an actual finish date. I want to apply conditional formatting so that if actual finish date is not equal to finish date, meaning a task can be finished ahead of schedule or a delay, then highlight that row. I tried conditional…
-
COUNTIF, ISBLANK, and OR formula
For a particular project category, I'm attempting to count how many times the "Project Status" column is either a blank cell or not "green" (aka complete). These projects will be marked as "Active" on my stats sheet. Here's the formula that I have thus far and I'm receiving an Invalid Operation error: =COUNTIFS({CDVL…
-
Filter display
Hello, I need a little help to get the filter to work properly. In a report, I applied a filter to get a display based on people and later by date but the display does not give the right result. You can see with the screen shoot Thanks
-
Stop Auto Formatting
I have a sheet with manually entered rows that are formatted gray to signify a day and if it's AM or PM. Users can then start filling in items below that row. When they enter their data, the sheet is using the auto-format function and also formatting it gray which is causing confusion. How do I stop smartsheet from…
-
Custom Welcome Screen not rendering properly
I have a dashboard with a lot of content that I wanted to set as the default welcome page. When I enable custom content and enter the dashboard URL I can see it in the preview, however when logging back into the system instead of the preview of the dashboard I get 3 windows rendered on top of each other. Each one is…
-
Ability to reorder list of sheets in left menu
When I am working on a sheet, every time I want to go to a different sheet I have to sit and study the list to find the one I want to go to. It is a waste of time and very frustrating. It would be SO helpful if I could put the list of sheets in the order I want them in. And have them stay in that order, unless I move one.
-
How to get the sum only for a Specific Dropdown Value Selected
Hi, I want to get the sum for only the dropdown value selected: Here is the Situation: First Column: I have 3 Resource Type: 1. Offshore 2. Onshore 3. Remote Column 2: I have resource Name Column 03 to 35 is a Hour Cloumn ( Where it shows how mnay hours each of my resource is available to work) Now I need to calculate: 1.…
-
Delay between Sheet and Report
I have several rollups and am having trouble today where when something is updated on a sheet it is taking quite a while to update across to my rollup reports. I noticed this when I added a dropdown option and again when I received an email update about a new item. I could see the item in the sheet but not the rollup. I…
