-
Counting Financials within Past 365 Days (Year to Date)
Hi, I have a Smartsheet that counts financial errors by individual. I want to change this so it only counts figures Year to Date. I'm therefore trying to manipulate my formula to only count within the past 365 Days. To make it more complicated, I'm referencing from a separate sheet. I've tried (TODAY) - 365 but unsure if…
-
How to auto-populate fields in a form based on a drop down menu?
Hi, I am trying to create a form based on a list of where for instance, one account has different line of business only applicable to that account, I would like these to be shown once the account is selected from a drop down menu. I was thinking on a VLOOKUP formula but I don't see how I can use this is the form creator.…
-
Formula to calculate difference between projected and actual dates
I have a project schedule where I have projected and actual dates for most of the deliverables, and I need to track the faster project path. Is there a formula that can automatically select the earlier date between the projected submit date and actual submit date? Is there a formula that will automatically select the…
-
COUNTIF date is this month
I'm trying to create a summary to only total projects that were added to my portfolio this month. I've got this formula to work in excel, but I can't get it to work in smartsheet. For reference, I'm a pro user. Excel formula: =COUNTIF(B2:B9,">="&DATE(2022,2,1)) Smartsheet formula: =COUNTIF({Added to…
-
Formula Help - SOS
I am not able to use the date in a formula and I am confused as to why the count is coming out as "0". Please advise! Trying to count the number of buildings that are not owned by ABC Inc., and contract signed on 02/01/22.
-
ALERT SOMEONE
I am having problem to setup automation to alert someone. I have a column that shows 4 rows and another column that shows when the Alert someone should be sent out: Citrix/Network/PC Comm 1 - 3 weeks [column Communication Released Date: 02/17/22] =PARENT([Network Migration Date]@row) - 21 Citrix/Network/PC Comm 2 - 2 weeks…
-
Moving rows/updating cells
I manage a portfolio of projects which I have to report on. I'm a Pro user, so I don't have the functionality that could probably make this task very easy. My project managers are required to use a company solution (not smart sheet to create project plans and updates). I've created a smart sheet that lists all of the…
-
Is it possible to get a count in Sheet Summary with the following equation?
=IF([CFO Install]@row = "yes, me only", 1, IF([CFO Install]@row = "Yes, my spouse and I", 2, IF([CFO Install]@row = "Unable to attend", 0))) I keep getting #unparseable. I tried COUNTIF(s), SUMIF(s) Right now I have been creating a separate column in my sheet with the formula to get the sum. I would like to clean up my…
-
Nested formula with sheet references help
I need a formula that will: look up a name listed on sheet #1 on Sheet #2 and pull the most recent date they completed training. So far I have tried two formula combinations and neither has worked. =IF({Training Data Range 1 - Name} = Name@row, MAX({Training Data Range 2 - Date})) #INVALID OPERATION =VLOOKUP(Name@row,…
-
sum values of a column in another sheet based on the column position
Hi all, Is there any way to sum a certain column in another sheet based on the column position? I think of having a reference like {another sheet range} with a range of e.g. 4 columns. I would like to sum the values of the second column, but do not know how to make this. SUM(INDEX({another sheet range}, 2)) will not work,…