-
Images in Dropdown List
Curious if images in a dropdown list would ever potentially be able to become a thing. I found this old (Circa 2016) archived post indicating that is coming in the future, so wondering if it'll ever be resurrected. https://community.smartsheet.com/discussion/4049/images-in-dropdown-list
-
Add colours the header row
Would be nice to colour to the header row instead of creating a duplicate header row in row 1 and adding colours.
-
Using nested MATCH/INDEX across multiple columns
Hi, I'm using two sheets to track the distribution of transportation gift cards, one will be a master list of the cards and the other is a webform tracker that distribution partners use to log who receives cards. I want the master list to check off each card given out after it is logged into the tracker, however each…
-
Why isn't my COUNTIF formula updating?
I am using the COUNTIF formula to keep track of quarterly reporting status for clients. For example, I need to track how many clients have a "failure to report" status. The row that I am pulling the data from is a dropdown selection - which I have never had issues with before now. When I plug in the formula, it registers…
-
Mass producing Dashboard with web content widgets
hello everyone, I created a dashboard to act as a huddle board for the business meetings and we will need about 100 different dashboards but dont want an update on one board to impact the other boards. We used web content widgets and when we "save as new" to make a copy - we are having to go in with the unique publishing…
-
COUNTIF formula returning 10 extra blank lines
I wrote a formula to count the total number of unassigned purchase orders in my sheet, which looked to be working at first glance, but upon comparing it to the actual data in the sheet, realized that it is counting 10 ghost orders. This is my formula: =COUNTIF({Assigned}, ISBLANK(@cell)) The Assigned column is a contact…
-
Why is my SUMIFS formula saying incorrect argument?
I'm working on a metrics sheet to power a dashboard. I want to sum our effort values for each of our chemists and each of our project categories. My ranges are: {MasterLead} : Column listing chemist on project {MasterEffort} : Column of effort values for each project {MasterRDCat} : Column of project categories I am trying…
-
Bug: Please Fix Auto-fill (blank rows)
Please fix the auto-fill bug. If I add a row to sheets via Forms, Zapier, or other automated tool, SOMETIMES there is a gap between the last good row and the new row. SOMETIMES this is single row, sometimes as many as ten rows. This causes auto-fill formulas to break. The result of this is hours of time by either me or my…
-
Merged: Partial formatting of the cell contents - Bold/Italic
This discussion has been merged.
-
Using a formula to count numbers of projects assigned to an employee and at what stage its at.
Hello! I've created a sheet to pull metrics from for some charts I need to make and I'm trying to create a formula that counts the number of projects that are assigned to each employee and its progress level. I more or less understand the first part of the formula counting the assigned projects, but I'm stuck on how to get…
