-
CountIfs- How many of one name in a date range
I have - a column containing start dates, that spans 2019 a column containing an assortment of names that re-occur on a random basis. I want to count how many times each name occurs each month. Any help appreciated!
-
Cell linking within a sheet
Hi there, I understand that you can link cells in Smartsheet between sheets, but I have been unable to link cells within a sheet - does anyone know if this is possible in any way? Thanks, Paul
-
count itmes in a column that is populated with multiple data
Hi guys, I have a new challenge for you :) . I have a list of projects. Each project contains different products. I have one probabilty column that contains all the probabilities to sell the different products contained in each individual project. An exaple: I have a project (1 row) where I can sell machines types A, B and…
-
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…
-
Automatically Sort Data
Hi, Our team works with a spreadsheet which currently is updated quite often / simultaneously by several users. We have been facing difficulties whenever new information is added, since sorting is not properly adjusted until we manually select sorting, refresh and save the data. Is there a way to automatically sort…
-
How export to Microsoft Project without dates missmatch?
When export my Project to Microsoft Project, start and due dates doesnt Match with smartsheet dates. Some one know that do I need yo do to hace the same information?
-
How do I send the same form out to folk multiple times where each new person answers questions in a
I have form that has multiple sections that is used for audits. During the actual audit day, a customer may find 30 issues. I need to capture those 30 items in the 1st section of the form with an owner (no big deal so far). Then the owners have a few weeks to manage and close their items. Do I ping the folks to update…
-
Looking for Smartsheet Consulting Expertise - Charlotte NC or Atlanta GA
We are looking for a Smartsheet freelancer that can help develop additional reports and dashboards. Prefer local to Charlotte NC but open to telecommuting.
-
Drag attachments from Outlook to Smartsheet.
I cannot drag an attachment straight from an Outlook email into a line in Smartsheet. First I need to save it localy, then attach. This is time consuming. Is there a way around (setting) I am missing? It would be nice to actually drag an email in Outlook to Smartsheet too. Thanks, Dave
-
Reports - pdf or Excel ?
I send regular reports to customers showing their expected delivery date of products. These dates can change frequently to suit their own construction schedules. Some customers prefer Excel format, others prefer PDF. If I need to change the email address of any customer, or add another name to their team, I am unable to…