-
Column Formulas in SUMIFS
Hi there, I'm currently using a SUMIFS formula that is as follows: =SUMIFS({v4 Hours}, {v4 end}, MONTH(@cell) = 12, {v4 Group}, OR(@cell = "AD", @cell = "Freelancer")) I want to sum the task hours column {v4 Hours} if the End Date for the task is in December, and the group has one of 2 values. Each {reference} refers to a…
-
Formula in % Allocation Column?
I am certain this has been asked either currently or in the past, but is the capability to include a formula in the % Allocation column on the product roadmap? Right now, I have a column entitled "% Alloc Calc" next to the "% Allocation" column to calculate the % Allocation for my users. The users must ensure that both…
-
Dual parameter formula to capture last entered date versus last date of column?
Currently have a sheet that allows an end user to utilize a drop down and date column to quickly input their activity related to a row. Once entered, a workflow copies the date and activity to a separate sheet with dates placed into individual columns. Using a MAX/COLLECT reference formula I am able to retrieve the last…
-
I will send you $100 USD if you can help me solve this
Hi there, If you can help me solve this, I will send you $100 USD via Paypal. My company generates leads for car dealerships across Canada. We will be using Smartsheet for our dealer partners to manage the leads we assign them. Each dealership will have their own sheet which their sales people will have access to (as well…
-
Formula to workflow a form submit that duplicates another entry
I would like some help please on a formula that would verify the submitted information from the FORM against all existing rows and inform the submitter/owner that a duplicate entry has been submitted. I want to workflow this so the row gets highlighted against the existing configuration of another row and informs the…
-
how to get sum of a column to include only certain date range
Please could someone help me with this? We have recently upgraded to be able to use the summary sheet as well as automated workflows, but neither of these have helped, and I think it maybe a simple formula issue? Basically, we use smartsheet for customers to place preorders of different products (approx 50 different…
-
IF/Match
Good afternoon, I'm having a problem with the below formula. I'm trying to do a formula that will check Invoice numbers on two sheets. If they match it will say yes, and if there is no match it will say no. However I'm getting Invalid Data type when there is a match, and No match if they don't match. =IF(MATCH(Invoice65,…
-
multiple admins using filter feature at same time
As with Excel, you have the function to share a workbook or sheet and each user can filter without impacting another user in the same sheet making updates to their information. Does Smartsheet not have this feature that would allow 3 admins of a shared sheet, make their changes or use their own filters to do there updates…
-
RAG indicator options
Hi there community I have a portfolio of several hundred projects being monitored and reported via dashboards and reports in Smartsheet. We are currently using RAG indicators against schedule as follows: Red - Incomplete at reporting date or due date passed Amber - at risk Green - schedule within tolerances (+/- 10%…
-
Is there a way to get the Proof function active in the Dashboard?
Hello All, I have embedded the card view of my sheets into the dashboard directly but we are not able to access the Proof function. A message pops up saying m"Proofing is not Available". I have searched through all of the settings and I can't find a way to make the function available. Has anyone figured out a way to make…
