-
Troubleshoot Workflows/notification not going to specific people (index/match formula driven)
Hello! I have a universal intake sheet to manage a variety of request. Assigned approvers are populated based on index/match formulas using a contact column. The notifications are working for everyone except one person. Oddly enough, when I push the notification as a test (and notify me), I don't get the notificationā¦
-
Smartsheet Calendar unable to update health status on source sheet
Hi, I created a Smartsheet calendar organized by Phase and then Workstream, with deliverable bars spanning duration. The goal is to create an interactive Gantt chart, which team members can update tasks on the calendar detailed side panel. The formula on the source sheet states that if At Risk is checked then Health isā¦
-
Countifs calculation get wrong number
Hi, I use a metrics table to calculate how many items in CNPA summary table. I want to calculate how many "Basic information" in Request Items column in CNPA summary table. The formula I used in metric table is COUNTIFS({Request Items},"Basic Information(location, die sizeā¦)") It returns 80. However, there are only 71. Howā¦
-
Metrics Pulling Help
Hi there! I have a submission sheet and a metrics sheet. I am attempting to create a formula on the metrics sheet pulling from the submission sheet. I have no trouble pulling counts, but averages are giving me some trouble.. I am able to pull the average based on 1 criteria, but no more than that. I am looking to averageā¦
-
Can i use collect function on images?
I have a an image pasted over a cell and when i use Index collect, it seems to copy the image but i only get "image.png" in bold and no displayed imageā¦ Any ideas how to fix this? Here is my formula: =IFERROR(INDEX(COLLECT(Photo1:Photo9, Department1:Department9, =Department11), 1), "")
-
Cannot get Automations to work the way I want
I'm trying to set up an automation for a task tracking sheet. I would like to send a weekly email notifying team members of their follow-up items for the week, and if they do not have any tasks, then they would receive an email stating as such. I have tried using the "otherwise" function, creating a second condition path,ā¦
-
How to update INDEX formula criteria in a specific way?
My company has created a freelancer invoicing system using two sheets. It depends on an INDEX formula that we now need to improve, which I'm having trouble doing. Sheet #1: A database with information on all individual freelancer (aka subcontractors) contracts (aka SOWs) Sheet #2: A form-based tracker with notificationsā¦
-
I'm afraid this solution doesn't exist but...
I need to assign a unique identifier to jobs that we budget/bid. Since jobs tend to be budgeted/bid multiple times prior to landing the work, we want to be able to see all labor costs associated with a job throughout the life of the estimating process. The problem here is that budgets often times are requested underā¦
-
COUNTIF with CONTAINS and multiple references
Hello, I have the following formula, that works in my database: =COUNTIF({Pain points}, (CONTAINS("CSMT", @cell ))) I need, however, to create another formula that contains this, but also adds another condition. I have tried these but it wont work, any help please? =COUNTIF({Pain points}, (CONTAINS("CSMT", @cell )),ā¦
-
Using AVGw function
Hi Everyone, In my Smartsheet project plan I originally set up a Planned % column using the following formula to calculate progress based on planned dates: =IF( OR(ISBLANK([Planned Start]@row ), ISBLANK([Planned Finish]@row )), "", IF(PARENT(Primary@row ) = "External Dependencies", "", IF( TODAY() > [Planned Finish]@row ,ā¦