Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
Card View Templates - formulas are missing?
Hi All - I am excited to implement the card view into one of our pipelines. I am basing this off of the "consulting pipeline sample" shown on the homepage of smartsheet. However, when I bring this template in, there are no working formulas for creating totals of the lanes. Am I missing something? Thanks
Jef
Comments
-
Hello Jef,
You're not wrong: I'm looking at the same template in Grid view and it appears there aren't formulas under the Total pipleline section.
I'm going to reach out to the appropriate team to find out why that might be the case, but in the meantime, you may need to write some SUMIF formulas. (I know, mostly defeats the purpose of using a template.)
You'll want to switch to Grid view, and expand the "Total Pipeline" parent row at the top to display the child rows.
In the "Service Revenue Forecast" column you'll want to place a formula that sums values in its own column when they contain the corresponding text string in the "Sales Stage" column. An example is as follows:
=SUMIF([Sales Stage]:[Sales Stage], "Pending Close", [Service Revenue Forcast]:[Service Revenue Forcast])
I've tested this to work correctly with the "Pending Close" total.
Note that this is specifically when viewing lanes by "Sales Stage."
-
Shaine, thank you very much, I will be able to run with this! I very much appreciate it have a great day!
-
Shaine - I have to admit, I want to use the card view, but I am really struggling to get the functionality working. I have my sumif totals working well, but they dissapear on the card view.
In the "consulting pipeline" template - the "totals" of the lane neatly show up at the top of the lane. How does that happen? Sorry for the trouble, feel like I am missing a big part of the documentation on this, and cant find it?
Jef
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.4K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 145 Just for fun
- 62 Community Job Board
- 464 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives