-
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…
-
How to get total count for projects releasing now through the next 3 months
Hi all, I am looking to count the number of projects due to release within the next 90 days. The closest I've gotten is: =COUNTIF({HCCE input sheet Storage Range 3}, <=TODAY(+90)), but it returns a count of zero even though there are several projects within the next 90 days. Any help greatly appreciated.
-
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 ,…
-
Calculate time between start date and today's date
Hello, Having trouble with creating a formula. I would like to calculate the number of days between the following two columns: Created Date & Today's Date I have a third column called Days Open where I would like the calculation to automatically generate each day. Can anyone provide me with a formula that would work for my…
-
Nested SUMIFS / OR / WEEKNUMBER functions
Hi, how can I combine these two functions? They are both working separately for me for the same range of data. =SUMIFS({MGHours}, {MGNum}, OR(@cell = [Project Num 1]@row , @cell = [Project Num 2]@row , @cell = [Project Num 3]@row , @cell = [Project Num 4]@row )) =SUMIFS({MGHours}, {MGDate}, WEEKNUMBER(@cell ) =…
-
Filter multiple sheet entries to display graph/total quantities on a dashboard
Hi Team, I have a sheet that is a total list of materials used on a job, divided into columns showing material type, size, length, quantity. Each day materials are removed from the store a record is entered into the sheet. I am wanting to display a summary or total of each type of material on a dashboard. I'm open to ideas…