-
Calculation Sheet for multiple sheets
Hi Guys I have a calculation sheet that is currently bringing in data from 3 external sheets in order to be able to create reports and graphs for dashboards etc My problem is that I am conscious I will reach my cell link limit, along with the fact that 3 or 4 more sheets will soon have to be included in calculations,…
-
Controlling Traffic Light Symbols Based on Comparison and Date Fields
Hello everyone, I am attempting to control the "traffic light" symbols, Green, Yellow, Red, based on a comparison of one field to another and a date range. Essentially it's a booking system where user inputs X and requests a date range. I'm trying to make it possible to book into the future and make my status symbol change…
-
Compare a Field if Column Can Contain Same Value More Than Once.
Hi All, I'm creating a booking system and think I am running into trouble with my formula because it's possible to assign the same value in a column more than once (so the formula doesn't know which row to look at possibly). Formula below. =IF(AND({DateCheckFlag}@row=1,[Asset Name]@row={DeviceName}@row),1,0) In my case, I…
-
Creating Reports for just the current month
Is there a way to create a report that only displays this month. I know there is a way to show X days in the past, future, etc. I have a formula in my sheet that shows the month number to be able to find the current month number, but I don't see the ability to display only that data?
-
COUNTIFS Resolved (or not) within 2 days over the last 7 days
I have the following columns: Date (I refer to this as 'Date Opened' below) Resolved (checkbox) Resolved Date Formulas in the 'Sheet Summary' section I am trying to create these formulas to reflect on the last 7 days, will be used to make a dashboard chart widget: Resolved on time (2 Days) over the last 7 days Count the…
-
Finding Duplicate User IDs in one column
Hello Smartsheet community, I'm trying to identify duplicate User IDs in the same column and in the same sheet. The typical user ID has 6 numbers in it (example: 100054). We are working with around 10k user ids. We've tried this formula: =IF(COUNTIF([User - Employee ID]:[User - Employee ID], [User - Employee ID]@row) >…
-
Calculate percentage complete on a project based on time elapsed
I need help to finish a schedule for projects based on time elapsed. The current formula that I am trying to use has a Datedif formula but I don't think Smartsheet supports that. Any ideas or assistance would be helpful? =DATEDIF([Projected Start Date]@row, [Projected Finish Date]@row,[Actual Finish…
-
IF AND with Less and greater than is not working
I am trying to use this formula. IF(AND([Time Remaining]@row = "Closed", [Closed Date ageing]@row >= 90,[Closed Date ageing]@row <= 180), "90-180 Days", "More") where [Closed Date ageing]=203 but still it is giving output "More" Can you please tell me where I'm making mistakes? Thank You Suman
-
Estimated Capacity Calculation
Hi All, I am running an estimated capacity calculation on Smartsheet, the raw data (=attendance tracker) is also stored on Smartsheet & the pages are linked to each other via references. I am using for the calculation headcount and the average of the monthly target, the only problem is that from the available headcount not…
-
COUNTIFS for assigned to CONTAINING a name
I'm trying to total the numbers of active assignments assigned to a person in a cell that can have muliple selections. .... it's not giving me an error but coming back as 0 =COUNTIFS( [Assigned To]:[Assigned To], CONTAINS("name", @cell), Status:Status, <>"completed") Anyone help!?