- Auto number column giving duplicated numbers
Hi All, I have an auto number column that I use in a formula to get row# but that auto number column is producing duplicate numbers and therefore messing up the formula. Does anyone know why it is giving duplicate numbers? Thanks.
- "If Match" formula
Need help with an "If Match" formula to search for if a cell at row is on a list and return a check to another column
- Date Summarization
Hello-- I've run into a puzzle that I cannot solve on my own. I need to group dates together by year to create a chart to show my leadership team. For example, I need all dates under Open 2021, Pending 2022, so forth. I've played with it for hours and I cannot figure it out. Any help would be most grateful. Thanks!
- Date formula to set cut off period
I am trying to set a date formula to for the following statement; if the [Next Due Date] is <= 27/07/2023 return "Performed" Example: =IF(ISBLANK([Last inspection]@row), "", IF(DATE(2023,7,27)) < [Next Due Date]@row, "Overdue", "Performed"))
- How to use Smartsheet as CRM
Hi, Has anyone used Smartsheet as CRM. Like for sending mass mailers and tracking when the mail was reached to the audience and who has opened it? Please suggest how can we do the same with Smartsheet. Please suggest if the same an be achieved with integration with any third party software. Thanks.
- Can I use groups to create series?
I have this report and from this I have created this Chart but I want it to drill down to the show the individual Branches on a stacked column chart like this. is this at all possible?
- How to reduce the frame of a report on a dashboard
Hello community.... I was wondering whether anyone has had experience of reducing the size of the view in a report on a dashboard (no, I don't mean by dragging the corner to make it smaller ) I want to show my report, but hide the title bar. E.g. the below image would only show number of racks and amps. Any ideas /…
- Handling URLs
Hi - searched far and wide, tried several things, coming up empty. We have a use case where a long link to somthing is inserted into a Smartsheet field (nor a form, just a grid). Can click ctl-K and make it to a clickable hyperlink. However, it ends there. We cannot index or join or even copy paste that clickable URL into…
- Workload Availability
Is there a way to be able to calculate employee workload based on the estimated hours per task considering that each task has a very different timeline. I have the field of estimated hours for that time period, hours for each task. In the end I want to see if they are exceeding their work hours for that particular period.
- Display Filtered Data in a Dashboard
Hello, I created a few filters which I would like to display in a dashboard. Is it possible to only display filtered data in a Dashboard? I cannot figure out how to do this? Help please.
