-
IF/AND Statement with CountIf
I'm trying to create a formula that will look at my "Measurement" column for the text "PBI" at the beginning of this formula: =IF([Rank/Actual PTR]434 > [Score/Goal PTR]434, "PTR Exceeded", IF([Rank/Actual PTR]434 = [Score/Goal PTR]434, "PTR Met", IF([Rank/Actual PTR]434 < [Score/Goal PTR]434, "PTR Not Met", ""))). So, I…
-
Dashboard - Source Reports
I'm new to Smartsheet. I'm trying to source a report to my Dashboard but it is only allowing me to select reports where I'm the Admin, but I'm the Owner. How can I go about adding reports that I'm the Owner of?
-
Jira Connector with Story Points
We have been successful, through trial and error, getting Jira connected to Smartsheets in a bi-directional fashion. One key piece of functionality that would be helpful is utilizing the story points from our Jira system. I noticed in the workflow builder we don't see that as an option to migrate our Jira Story points into…
-
Cell Linking and Circular References
I have created one parent sheet with multiple columns of information that I have copied into more limited child sheets. I've linked in all of the information in the child sheets from the parent sheet, so when the parent sheet is updated, the child sheets update with the related information. I do however want to give users…
-
Change in source dashboard template after copying a folder
After using Save as New to copy a folder from one workspace to another, I noticed that a dashboard template in the source folder seemed to have changed in that three recently updated widgets were now indicating "Missing source sheet". There is no indication that this source dashboard template or the related "missing source…
-
Cross Sheet Reference Unparseable
I am trying to use a COUNTIF statement to reference another sheet and count the number of "V" s so I can create a metrics sheet for my DashBoard Creation. I have attached a snip of it below but all i get is #UNPARSEABLE when i try it. I must be missing something, but I am unsure as to what. Received the #INCORRECT ARGUMENT…
-
Hierarchy in Smartsheet and Jira Connector not working
I don't seem to be able to get any hierarchy to work using the Jira connector. Smartsheet Hierarchy When I first sync'd my smartsheet with Jira all the rows were rearranged and the entire hierarchy in smartsheet was lost. So I figured out I need to use Group by in the Jira connector to respect the Smartsheet hierarchy.…
-
Planning : expected vs reality
Hello ! Does anybody know if how to show on the same line of the Gantt mode, the expected planning and the reality. Here attached is an example of what I need. Thank you for your help !
-
Sum Values Between Two Dates
I'm looking for some help with a formula. I've created a complicated system of sheets where a contractor enters her/his hours into a form each day they work and I link the data into a contractor's individual sheets which then feed into a series of formulas which feed into reports which feed into sights. What I need to do…
-
Report filter that includes "Today" correctly shows the rows on the report, but not when displayed v
I have a report that is set to show rows that have a "Date Published" column where the Date is equal to today or is in the past. For examples sake 12 rows in total. 4 rows have a past date, 4 rows have today's date, and 4 rows have no date or a date in the future. When viewing the report directly, the report is correctly…
