-
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…
-
Updating Smartsheet from external sources
I have a task list (for want of a better term) that was made in SharePoint and shared with many users. They make updates. I then export to Excel, import to Smartsheet and do what I need to to make an informative report. I can't remove the SharePoint element from this process. I need a way to update some of my information…
-
IF and TODAY
Hi, I have the below formula which is working correctly: =IF([Item Name]@row <> "", IF(ISBLANK([Actual Sign Off Date]@row), "TBC", IF(AND([Actual Sign Off Date]@row <= [Sign Off Required Date]@row), "ON TRACK", IF(AND([Actual Sign Off Date]@row > [Sign Off Required Date]@row), "DELAYED")))) I have another formula which is…
-
Trying to count total dates in a column for a specific date range
I'm trying to count the number of submissions of a specific activity in a specific time period. For example, I want to count the number of submissions for Task A in (Task A/B column) that were submitted in the period >=3/6/23 to <3/14/23 in (Submission Date Column). I have filtered the file manually and the correct number…