-
Create a template set with linked cells
I use two sheets to track one project. I use these same two sheets for many projects. One is a fully detailed list of every task's status, assigned to, and start/due dates, and the other is an abbreviated version that only contains specific tasks for a person(s) that is assigned to the project. Every cell in the…
-
CountIf with Date range
I am trying to count the number of requests types between a date range. This is what I thought would work: =COUNTIF(({Request Tracker Range 4 - Request Type}, Category5), AND({Request Tracker Range 3 - Date Requested}, DATE(2019, 01, 02:2019, 03, 14))) I am using this formula to count the entire column =COUNTIF(({Request…
-
How to Setup COUNT/COUNTIFS formulas
I manage the educational benefits at my job and am trying to find totals of how many dependents, drivers, and office employees participate in the benefit. This is how I've been setting up my formulas. Yet when we cross reference with Excel the total number is off. =COUNT(DISTINCT(COLLECT([Employee ID/Driver Code]:[Employee…
-
Edit contact display?
Hi Do you know if you can edit the display of a contact in an assigned to column? Ideally I just want to see the initials in the icon and not the name/ email that follows. Thanks, Jo
-
Different Locations for Smartsheet Engage
It would be nice if, on occasion, Smartsheet Engage took place on the East Coast, or better yet, somewhere in the Midwest(Illinois, Indiana or Ohio perhaps).
-
Use Reports to create graphs on Dashboards
I think with the extreme power of reporting on smartsheets and being able to get all the data you want in one place from multiple sheets, you should be able to link the report to create a graph rather just embedding the report into your dashboard. You can do both the report embedded but create a graph with the data as well.
-
Smartsheet University
Allow people to bookmark trainings/classes they would like to take in the future. From what I can tell, there is no way to save classes you want to take later. Then if I cannot take the class at that time, you need to find it again later.
-
Pull data from one sheet to another with same words
Hello, I am fairly new to SmartSheets - I am trying to figure out how to pull data from one sheet to another that would have a names in common. I.E. Sheet 1 has a course name of Smith AR Training. Sheet 2 has the Region Name as Smith in one column and then a contact person in the 2nd column. Because Smith is listed in both…
-
Modifying a date based on 2 variables
Hello Everyone! I would like to create a formula that says If the value in the "Variable" column is "HIGH" AND the date in "Column 1" has a year less than today's year, return that date with TODAY"S year. Otherwise return that date unchanged. In other words, dates in the previous years are brought to this year, dates in…
-
Using Countifs with multiple references to other sheets
Been playing with this for a while but can not seem to get this right. Any help would be appreciated =COUNTIFS({Editing List-3-2018 Range 2}, >=(DATE(2018, 7, 1), {Editing List-3-2018 Range 5}, ="Name"), Date:Date, <=(DATE(2018,6,30), [Assigned to: Editor]:[Assigned to: Editor],="Name")
