-
If forumula
I trying to write a formula if (Days)<=30 will display an Amount in column 0-30
-
Forms
I created a smart sheet that notifies the appropriate lead when someone is requesting access to a project. All the formulas, filters, and alerts are correct. The issue I'm having is when a form is filled out a new row is created the formulas aren’t being placed in the appropriate cells so the notifications for leads would…
-
At Risk Report with parent and only some select rows
Can someone please assist with reporting at risk line items? I have parent/child hierarchy and want to only report those parents that are over budget and only the line items under that parent that have fees greater than 0.
-
Clean up Sumif Formula
I have this formula to give me the sumif for multiple criteria I was just wondering if there is a simpler formula =SUMIF(@{Healtcare Range 3}, @cell = "Memberships", {Healtcare Range 2}) + SUMIF(@{Healtcare Range 3}, @cell = "Sponsorships", {Healtcare Range 2}) + SUMIF(@{Healtcare Range 3}, @cell = "Client Seminars /…
-
Countifs same column different criteria
Hi I'm trying to count the items in the in one column if they are not equal to criteria in another column. May someone assist. This is what I have so far. =COUNTIFS({FDA Submission 2019 Range 1}, "DE Novo", {FDA Submission 2019 Range 2}, OR(@cell <> "Approved", @cell <> "Rejected", @cell <> "Withdrawn")) However everything…
-
NETDAYS based on IF statement
I'm trying to use a NETDAYS function to determine how many days overdue a payment is, but I only want to display that number of days if a column named 'Status' has the value 'Client payment pending'. The function I'm trying to use is =NETDAYS([Date Sent to AP/CR]398, TODAY()) but I don't know how to work that into a…
-
Sumif WTheck?
Hello - I am trying to draft a formula to sum the column 9 but only when column 3 is "John Smith" and when column 11 is not equal to "complete." I got this far, but can't figure this out: =SUMIF([Column9]:[Column9],Column3; column3, @cell="John Smith")
-
Salesforce ServiceCloud Users/Connections
Hi Smartsheet Community, We're thinking of some use cases for helping Smartsheet users utilize Salesforce ServiceCloud data more effectively and efficiently. Any Salesforce ServiceCloud users out there who would be willing to chat with us and give us feedback on our use cases? Even if you don't use ServiceCloud but know…
-
Vertical Layout for Alerts
Is there a way for us to control/customize the format of the alerts we receive between vertical or horizontal? We prefer the vertical formatting over the horizontal as it is easier to read and the formatting carries when we have to forward the email. I have several sheets where when I first set-up the alerts, they came in…
-
COUNTIF between Dates
I have a formula (see below) where I'm trying to get a count where multiple criteria apply. The first date range renders a correct count but fails once the second one is added. I've tried multiple iterations of the formula, this is my current one. If it is not clear from the formula, I'm trying to count tasks assigned to…
