-
Calculation for Variance in Percentage between Target column and YTD Column
Hello Community; I'm building a dashboard to reflect how different projects/programs are tracking towards targets. I want to showcase the following: 1) Projects that have gone above their targets, 2) Projects that didn't meet the target, 3) Projects On track to meeting the targets. I've already tried this formula…
-
Logging modified date/time of data in a column
Hi you all. I'm currently in the process of analazing some trends in a particular operation and one of the most valuable sources of data would be the ability to extract the modifications log for every cell on a particular column in a spreadsheet. So far I've looked for such functionality over the site but can't seem to…
-
Can we assign clients and link their info line to staff's individual work sheets?
We have a master list that talent inquiry forms populate and notify a manager. Once the manager assigns that client inquiry to a staff member, we would like to have it copied to their personal work pages. These pages then need to stay linked to the main page in order to keep updated notes, attachments, and status accurate.
-
Concatenate, Join, and Index
I am looking for a way to pull data from Sheet A into a helper sheet, concatenate and join the data, and then push the result into Sheet B. Sheet A might have 1 parent row and up to 10 children or 1 parent only or any combination thereof. I am having trouble hitting on the right formula without it being a manual process.…
-
Can I use Vlookup to check a date range!
Hi All, I have a multiple scrum board sheets. In these sheets I have a closed date column. I also have a field with the Sprint # an Quarter. This sprint number field is not relevant to the task owners, it is more to internally map the tasks and do some statisctics. I have another sheet (my refernce sheet) which gives a…
-
Index,match,match
I'm having the hardest trouble figuring this part out. Even after doing some searching and people asking for the same thing. When i try to use it on my sheet it doesn't work. I want to do excel's version of index,match,match. I've tried index(collect), join(collect), max(collect), but i am doing something wrong apparently.…
-
Counting Multiple Columns with different criteria
Hello! We manage properties with under different statuses (Available, Expired, Under Contract, etc.) and use another Column called "Dead" to filter our reports. We created a checks and balance sheet to view the counts at a glance for high level overview, and we are unsure how to use the =COUNT and =COUNTIFs on two columns.…
-
Formula from Excel Help
Hello community, I cannot figure out why this formula is #UNPARSEABLE in Smartsheet when it works perfectly in Excel. The intent is to show the amount of days left before/after "Due Date" [Column5]. EXCEL =IF(E2="","",IF(E2<TODAY(),-DATEDIF(E2,TODAY(),"d"),DATEDIF(TODAY(),E2,"d"))) SMARTSHEET…
-
Formula/pie chart help?
I'd like to have a pie chart that shows a dynamic count of orders "pending/fulfilled/cancelled" of the last seven days. Ideally, there would be four separate ones for four locations (which will be presented on their personal dashboards), as well as a master graph that compiles the data for all four into one for upper…
-
Adding "$" sign to an ABS formula
I'm doing a round-up formula for budgets and the formula works $8,378,398 shows round to 8.38M - formula is =IF(ABS(Budget55) >= 10 ^ 9, ROUND(ABS(Budget55) / 10 ^ 9, 2) + "B", IF(ABS(Budget55) >= 10 ^ 6, ROUND(ABS(Budget55) / 10 ^ 6, 2) + "M", IF(ABS(Budget55) >= 10 ^ 3, ROUND(ABS(Budget55) / 10 ^ 3, 2) + "K",…
