-
Timeline View Conditional Formatting Color Not Updating in Real time and requires refresh of page
I have a grid sheet with formulas and conditional formatting set up so that when the Status of a row/task changes, the row color and icon update accordingly (e.g., when Status = “Staged,” the row turns yellow and shows a yellow icon). These colors have always carried over correctly into Timeline view. Previously, if I…
-
Substitution for COUNT/COUNTIF Function
I am trying to pull information from a shared sheet that is considered the intake for all projects to a metrics sheet for a count of items per each calendar month that will be used as reference for a metric dashboard. The month column was hand typed at one point but was recently replaced with a column formula to…
-
How can I get calendar view to stop showing wildly inaccurate dates?
I have a grid view and two columns are assigned to start and end dates that define some intervals that get mapped to calendar view. The dates are all formatted correctly in the grid view. The problem is that the dates that show up on the calendar view are wildly inaccurate. Certain events show up as the wrong dates,…
-
Can't use the new "Timeline View" when leveraging the new "Columns Link" in Table View
What I'm trying to do: I'm trying to leverage some of the new/upcoming features from Smartsheet to put together a sheet that brings information from multiple sheets to generate a timeline view of our Program Portfolio. The problem I'm facing: Column Linking in Table View uses essentially column formulas. Timeline view and…
-
How to automate data involving dates and sum totals
I have been researching this topic for some time now and have been having trouble finding an answer - hoping the Smartsheet hivemind can help! OBJECTIVE: To obtain a sum total of data submitted via a Smartsheet form, based on submission date. CONTEXT: I work for a transportation company, and we use a Smartsheet form to…
-
Index or MATCH formulas
Hello I think I need an INDEX and MATCH formula. Basically I have 3 lists, broken down into Region - list of 7 names ICS - list of 42 names Trust - list of 100+ names What I want to do is when I select a Region (ie Midlands), it will then select the ICS list under that Region for me to choose from. Also when I select the…
-
Can't Find Option to Reference Another Sheet with new AI-enabled design
I was a away from Smartsheets for a few weeks while switching jobs and I can't find some stuff now. A month ago, when doing formulas that had the capability for a cross-sheet reference, Smartsheet would offer you a link to "Reference Another Sheet". Smartsheets a month ago: Now, when I try to use a formula, a pane on the…
-
Dropdown Link to another sheet is not working
I was able to successfully set this up last week. Today it is not working. I created two dropdown columns referencing two different sources into a single target sheet. This is still working correctly. However, I am unable to create any additional linked dropdown columns as of today. In the column properties I can access…
-
JOIN + ACCOUNTING
Hello, SmartFam! I'm trying to join text with accounting numbers. but the join will not keep the financial formatting (removing the $ and correct , placements) Can you please help me get this right? VENDOR AMOUNT JOIN RESULT DESIRED RESULT AMAZON $435,678.90 AMAZON - 435678.90 AMAZON - $435,678.90
-
Child row and Multi- contact cell selections
I am currently developing a portfolio management system in Smartsheet to centralize our work. To accommodate multiple project owners, we are utilizing a multi-select contact cell. When a user is assigned as an "owner," the initiative appears on their individual summary sheet. However, we have encountered a challenge: in…