-
Cross-sheet predecessor without using cross-sheet reference
In sheet 1 there is a date 1 which is a predecessor (SF type) for last task in sheet 2, so that date 1 is later than any task in sheet 2. When I use a cross-sheet reference to import the date 1 into sheet 2 and then simply use it as a SF predecessor, it does two things that I need to avoid: it erases the critical path for…
-
Conditional Logic - Drop Downs
Hi there - I have a form, and am using Conditional Logic to show/hide certain fields, but had a question. Is there a way to show a field and only certain selections from that field? Here's an example: Person selects Retailer A from a drop down. As a result, a drop down (Promotion Options) appears (among other fields). What…
-
Editable Font Size and Colour for Data Labels on Charts
It would be helpful to have some control over the size and colour of data labels for charts. e.g. if your dashboard font sizing is consistently a smaller or larger size than the default for data labels, it looks untidy, often data labels appear too large on a chart as a result of the large default font size too.
-
Sort Chart Data in Dashboards (Ascending or Descending or Alphanumeric Order)
Please add a feature that lets you sort your chart data in ascending order (e.g., 1, 2, 3, 4), descending order (e.g., 4, 3, 2, 1) or alphanumeric order (e.g., 1, 2, 3, a, b, c).
-
Dynamic View Logic should behave like Conditional Form Logic (aka "live")
Logic in Dynamic Views should work as it does in Forms - changes / info entered while filling out the form results in changes to the form based on established logic. Instead, DV Logic is applied only when a request is loaded or saved. This is a follow-up to an old discussion on Dynamic View logic behavior (here) PAIN…
-
Locating the parent of a parent
I am trying to take the value from the primary column of a level 0 parent and insert it into another column in a level 2 child. =PARENT([Task Name]@row) works fine when there is only level 0 and level 1. Something like parent of a parent is what I have imagined would work, but =parent(PARENT([Task Name]@row)) is…
-
Cell-level Comments
Cell-level comments would be a huge time saver (similar to Excel) and in the Comments feature bar there could be a tab at the top that reads "Cell" next to the "Row," "Sheet," and "All" tabs. Currently, I'm spending a lot of time describing columns and going back and forth on communication to confirm columns and which…
-
INDEX and MATCH across two sheets: a detailed explanation
Hello everyone, would love some feedback on this tutorial. I was answering a user's question regarding INDEX and MATCH (thread post here), and thought it would be beneficial to share my example to the greater Smartsheet community of how to easily utilize INDEX and MATCH functions to reference cells from another sheet by…
-
Can not move my sheets/reports between folders
Im trying to create new monthly duplicate folder with all shared links we are using for our data project , for some reason i can not move sheets and reports between folders , only to workspace that not commonly used by us Anyone is facing the same , your support is appreciated Thanks in advace
-
Item Changing with New Information Need Reporting Help
I have test for items a,b,c,d and a report that is pulling data from those tests. Occasionally I'll have an item that will turn to a version 2 now considered a2. Column information wont change. Now there will be an a, b, c, d, and a2 rows. What should I do to pull the correct information to my report now that a (the…