-
Reproducible Hyperlinks
I'm compiling a hyperlink section to include at the top of project sheets, a little more than a dozen in total. This collection creates my tabbed "Excel report". It will allow end users to navigate to the tabs/sheets they need. I can then save them in their feature (finance, schedule, risk, invoices, cash flow, etc)…
-
Updating a Date Column after another cell is updated.
I am trying to have a Date Column update with today's date when a single select option is chosen. I don't want to use the system update date column because that will get updated whenever any cell is selected. For example: I have a single selection column with several options: Estimating Complete, Quote Sent, and Sale. I…
-
RYGB Symbols Average Formula
I currently having issues with creating formula that gets the average of 4 cells that have the option of 4 different symbols (Red,Yellow,Green,Blue). The goal is to show the average of the four cell symbol's in one here is what I have so far. =IF(COUNTIF([PW Goal]3, [BB Goal]3, [JQ Goal]3, [MC Goal]3, "Red")) = 4, "Red",…
-
Datamesh from a summary report
hi! I am trying to build a means to automatically forecast vendor costs, based on a count. I have a large sheet that contains an intersection of many Locations and the Scopes that will be applied to each location. I have different vendors servicing my various locations. I have created countifs formulas to count the number…
-
New Columns Not Available to Select in Report Builder
I am using the Communications template Smartsheet has available. I modified the categories to suit them to our business. I went into Report Builder to modify the report and the categories do not appear to select. Just for testing's sake, I changed all the categories back to the original names and report ran and calculated…
-
Best practices when dealing with large amounts of reports
Good afternoon everyone, I was curious to know what everyone's best practices are when it comes to managing a large number of reports and how to implement holistic changes? We have dashboards designed for multiple locations and in those dashboards are reports that are filtering content from a sheet, filtered to those…
-
Summary Report - COUNTIF of multi-selection columns
I love the way a Summary Report can kinda be a poor man's pivot table within Smartsheet, and it works really well, up until you try to do conditional counts of columns with multiple selections. See below. What's happening here is I want to allow a COUNTIFS when a person is chosen, and count the number of instances data…
-
Dashboard Header Banner
I want to use an image for a Dashboard banner however, I cannot find any size dimensions for it and some experimentation is not working. I note this shows on Smartsheet's own examples yet I can't reproduce it. See attached screen shot.
-
Help improve my data collection process, with multiple forms, update requests, approvals, reporting!
Hi All, I'm considering using Smartsheet for a somewhat complicated process and I could use some help thinking through how this might work. I have the basics listed below but I would appreciate if the experts here could let me know if you see any issues or improvements. Sorry for the long post. Thank you! Need: Need to…
-
Portfolio Management - airtable vs smartsheet
I have been asked to look at Airtable. Currently our team uses smartsheet. Our team is leaning towards Airtable due to its easy and customized views, plus ability for executives and stakeholder to create their customized views. How good is airtable compared to smartsheet How good is airtable for work collaboration - so…