-
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,…
-
Want to Calculate Crew Required Based on Specific Dates
Below is the screenshot of the formula I am trying to use but it always returns 0, Please guide Thanks!
-
Formula for automatically pulling rows of data from one sheet to another using checkbox
Help please 🙏 I need a formula or solution for automatically pulling rows of data from one sheet to another using a checkbox... So sheet A has a ticked checkbox, meaning I need the information from most columns in the ticked rows moving over sheet B every time a sheet A checkbox has been ticked.... (I need name about 5…