-
Report Keeps Saying "Column Not Found"
I have my sheet set up and saved. Then, I created a report based on columns in the sheet. I added the following columns, saved the report. Data already in the sheet was showing in these columns. Now three times, I've opened the report, and these columns keep showing up as Columns Not Found. I unchecked the columns and…
-
How Are You Automating RAG Status Roll-Ups Across Complex Project Hierarchies?
Hi everyone, I’ve been working on improving how RAG (Red/Amber/Green) statuses roll up across multi-level project structures (Activities → Tasks → Project Summary), and I’m curious how others are approaching this. Currently, I’m using formulas like: Child → Parent: Prioritizing Red over Yellow over Green Parent → Summary:…
-
Add ability to format text box outline width and color with conditional formatting
Add ability to format text box outline width and color with conditional formatting.
-
Simple Star Rankings
Here's a single formula to show star rankings (including half stars) for anyone who's interested: =IF(ISBLANK(Rank@row), "", IF(Rank@row = 0, "☆☆☆☆☆", IF(Rank@row = 0.5, "⯪☆☆☆☆", IF(Rank@row = 1, "★☆☆☆☆", IF(Rank@row = 1.5, "★⯪☆☆☆", IF(Rank@row = 2, "★★☆☆☆", IF(Rank@row = 2.5, "★★⯪☆☆", IF(Rank@row = 3, "★★★☆☆", IF(Rank@row…
-
Sync for Procore Still Working?
I was reviewing Sync for Procore | Smartsheet, but I'm getting errors with the cyberco.com/products/sync (How to get it, Step 2) and Smartsheet Sync for Procore Support (Additional Resources) links found on that page. Is this service still supported?
-
Color coded drop down list - NOT the cell color
When I created my sheet I somehow color coded the dropdown list with individual colors. But when I add a new item to the dropdown list, I can't seem to figure out how to get it to color code. I am not talking about the cell background. You can see in the picture below that it is just the "bubble" around the words. How do I…
-
Create a formula to return a check mark
Hello, I am looking for a formula that will return a check mark. Here is what I am using however it comes back #UNPARSEABLE =IF([Personnel Cost Metrics - Overtime]@row "<=3%", 1, 0) Appreciate the assistance.
-
Unable to Calculate Event End Time from Start Date and Duration
I’m trying to confirm if it’s possible to calculate an Event End Time based on our current fields. We have a report that we pull into Smartsheet On Smartsheet: Request Start Time (Duration) Duration (duration field in minutes) Event End Time: (Duration) Formula's that I tried: =[Event Start Time]@row + ([Duration]@row /…
-
Lost access to Smartsheet Data
I have not used Smartsheet for several months and my subscription expired. I now wish to resume using it but all my folders nave disappeared. Is there any way of retrieving them?
-
Dynamic View $ Formatting
We have a sheet with multiple columns of dollars, formatted with no decimals for ease of reading. However, the dynamic view directly from the sheet is inserting decimals, which changes the value of the $ and does not accurately reflect what we are reporting. Is there any way to maintain the cell formatting that from the…