Good day, I am using the pivot table to populate a chart on a dashboard from 3 columns on a sheet. Salesperson, month, contract value. that translates to a single line per sales person that I use to populate the chart. It is designed to maintain a running total of what work the salesperson has requested to be booked versus…
I am using this excel form to quote repair work. I would like to link the cells in the excel form to the columns in the smart sheet.
I have a sheet that counts if there is anything in a cell, however to the possibility of a incorrect entry I would like a formula to count if the word Jira is found in the column and if there is a number in the same cell which will be unique in every cell. =countifs({Range}, "Jira") works for the text how can I also…
I have a formula that counts distinct entry's in a column "IFS Service Location" (to avoid counting duplicates) and in the "booking status" column had a status of "ready to book". . =COUNT(DISTINCT(COLLECT({IFS Service Location ID}, {Booking Status}, "Ready to Book"))) I would like to change the citerion_range1 to a…
我怎么能有这种本事,表发送一个变焦meeting invite from a sheet based on responses to a form to Larry? For instance: Larry chooses to attend a training on 4-22-22 at 8 am from a form he received a link to.
I am using this formula to convert the numerical date to a text Month only. It works, however there is now a zero in front of the text. Does anybody have a suggestion for a solution. =IF(MONTH(Created@row) = 1, "January") + IF(MONTH(Created@row) = 2, "February") + IF(MONTH(Created@row) = 3, "March") + IF(MONTH(Created@row)…
I have a sheet with values, Dates created and Sales Person. There are multiple Sales Persons attached to multiple values and dates created. I have used SUMIF to gather and total the values per month. =SUMIF(Created1:Created211, MONTH(@cell) = 8, [Contract Value]1:[Contract Value]211) How can I also break the values down…
