-
Sum Values Between Two Dates
I'm looking for some help with a formula. I've created a complicated system of sheets where a contractor enters her/his hours into a form each day they work and I link the data into a contractor's individual sheets which then feed into a series of formulas which feed into reports which feed into sights. What I need to do…
-
Report filter that includes "Today" correctly shows the rows on the report, but not when displayed v
I have a report that is set to show rows that have a "Date Published" column where the Date is equal to today or is in the past. For examples sake 12 rows in total. 4 rows have a past date, 4 rows have today's date, and 4 rows have no date or a date in the future. When viewing the report directly, the report is correctly…
-
Looking for a requirement template in Smartsheet
Hello, I am looking for a requirement template, does anyone know of one or has built one already?
-
Day and Time
Hi, Is there a way to track time of day by task? Thanks Cheri
-
Counting Check Boxes Across Multiple Sheets
I have the same sheet for 7 different individuals that has 12 columns and 38 rows...each cell is a check box. I want to create the same sheet that shows a count of each sheet per cell. So, how many of the 7 sheets selected row 1, column 2? How many selected row 1, column 3? And so on. I have seen numerous discussions about…
-
Vlookup or Index with Match?
Trying to get data from one sheet to another by matching on Deal ID to the Requests sheet from the Salesforce sheet Could someone please help me for the formula for this? this would be an import from salesforce that I would have to do manually weekly, so I could rename the imported file and use same column names each time.…
-
Displaying multiple column values in Calendar view
I am storing data related to issues in the smartsheets. How can I show the issue number and priority in the calendar view?
-
Hyperlink function
Hello all, Is there a way to do the following: =if value in Column A, return hyperlink to Column B This is not a website hyperlink, this is a hyperlink to a smartsheet item. I have tried pulling hyperlinks through VLOOKUPs, nested if statements in the same sheet, etc. Manually clicking through and adding hyperlinks 1 by 1…
-
Alert(s) Updating a "Count" Sheet?
I have an end user I am trying to build a records sheet for and I can't figure out how to accomplish a change count cleanly. We have thousands of rows/records in a sheet with one of the fields/columns being a Status.They do a monthly review of how many records moved to different statuses in that month and I want to…
-
Confused by users and resources
I'm pretty new to SS, which I've been added to by my project's owner as their preferred tool. We have set up a high-level schedule with gantt chart to get a top-level idea on estimates. I've assigned tasks to people (adding them as needed) and got a pretty gantt with a critical path, but have no idea how utilised each…
