-
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…
-
Streamlining sheets
We have a sales staff that is utilizing multiple sheets, for potentially the same client. I want to rundown the "standard" process to see if anyone can help streamline this. Sales speaks to customer, and enters into SmartSheet, almost as if utilizing like a CRM. This sheet will store details like Name, date contacted,…
-
Reports Overwriting data in Sheet
I have a sheet that I use for collating data of time taken on a particular works order. To compete a works order, it requires 3 seperate workstations. However, I have set up 3 seperate reports, linked to the one sheet, for data input. The issue I have is that if two workstations both enter data at the same time, and one…
