-
How do I list all predecessors (direct and indirect) for a given row?
Does SmartSheet have a way to list out all of the predecessor rows that feed into a given row? For Row 22 in the example below, I would like the formula to return the values 20, 19, 18, 17, & 16. Either that, or I would be looking for a list of all direct and indirect successors to a given row. Either would get me where I…
-
Report for Non-Aggregated Days
Our contracting companies submit invoices monthly, and the invoice dates reflect the actual calendar dates worked. However, in Resource Management (RM) and Advanced Reporting, time data is aggregated by week. When I filter for January 1–January 31, the system returns data based on the week-ending date. As a result,…
-
Enhacement Request : Hide & unhide rows and colums with conditional formatting
Hello, It will be useful and efficient to have below functiobalities in future smartsheet releases: 1. Hide & unhide rows and columns 2. Hide & unhide rows and columns with conditional formating Regards Faizulla
-
Export with ALL comments
I can't seem to find a way to include all comments in an export to Excel. The export only shows the latest comment or set of comments. Pulling a row report doesn't give an option to include comments. And the Conversations view doesn't give a way to export all the comments from that angle, either. Any ideas to gather all…
-
UPDATE - Health and Wellness Solution
Here is what I have built out so far for my Health and Wellness Solution. Please note some information has been redacted, including my Forms Dashboard which is where I go to log most of my entries, it is more for me to see, it's not as pretty as these are. I'm a dork and record many things just for the fun of it. I started…
-
Checkbox Evaluates Differently
I have a checkbox column [H-SD (Added)[ with this formula: =IF([H-Supplier Type]@row = "Individual", IF(COUNTIF({SD-EmailPrimary}, [Email (Primary)]@row ) > 0, 1, 0), IF(COUNTIF({SD-EmailPrimary}, [Organization (Email)]@row ) > 0, 1, 0)) In another column, i want to evaluate if that column is checked or not, so I put this…
-
Ranking when duplicates
I need help with a challenging formula. I have the following situation: Row# Value Score Effort Score Priority Score Rank* 1 50 5 45 4 2 70 10 60 1 3 65 5 60 2 4 60 20 40 5 5 70 25 45 3 If Priority Score = Value score - Effort score then rank by priority score (with greatest priority score = rank 1) if priority score is…
-
Dynamic view time-stamp issue
I am set up in CET, and I set up a dynamic view where the time stamp column (time created) in the sheet is transposed to the dynamic view with a +6 hrs. This is kind of inconvenient… is this an issue that can be resolved? e.g. 12:01 pm appears as 18:01 in the dynamic view vs. 12:01, 11:40 am appears as 17:40 in the dynamic…
-
Changes to license requirements for Editing
I have hundreds of hours in building sheets that link multiple teams. This was all done on the premise that we wouldn't need 100s of licenses for simple cell updates. All of a sudden I am getting bombarded by users saying they cant edit only to find out we now need licenses? I love the Smartsheet core product but this has…
-
Creating child rows with form selections
Newbie here! I have created a form for marketing requests. One of the drop down fields is for Marketing Avenues with 13 possible selections. I would love to find a way to auto create child rows for each avenue selected under the parent project row so we are able to assign those to different people and keep up with each…