-
Count String Occurrence in a Cell
Hi There, I have below two columns in my sheet. Column [Status (Delivered)] has concatenated values (WIP and Delivered). In [Delivered Count] column, I need to show how many times 'Delivered' string occurred. Please see below example.
-
INDEX MATCH
Hi all, I have two table. In the first table I have band names in the first column like ACDC and a contact column (where the formular should be used). The second table will be filled via form. First column is the submitter second is free text. If the free text is "ACD" it should match with "ACDC" and the email from…
-
Generated Document has extra boxes
Hi I'm having problems with a generated document. It has additional boxes on the generated document. We double checked the PDF and there are no boxes in those areas. Does anyone know how we can fix this possibly? This is the form when not generated This is it the generated document Thank you for your assistance!
-
Smartsheet vs EU Smartsheet
The recent change in EU data privacy is causing some of my project team to not be able to collaborate with on my projects. They keep getting an error pointing them to Smartsheet EU. I also thought I read somewhere that the two versions of Smartsheet don't talk to each other. Is anyone else experiencing this issue and if…
-
Canvas for Forms
With all the buzz about a wider canvas now being available for dashboards, wouldn't it be cool if we could have a similar canvas for designing forms? This could eliminate the amount of white space and linear formatting by allowing us to place our form fields and sections anywhere on the canvas vs. just top to bottom,…
-
TIP: How to reference a \ backslash or " double quotes in formulas + [ ] in Col Names
While researching a problem I had and the absolutely simple solution that was causing it, I decided I would write this post to help people in the future. This is not an official post, just me trying to give back to the community in hopes it helps someone, so if you have more info to add (or correct me) please post it…
-
Moved: TIP: How to reference a \ backslash or " double quotes in formulas + [ ] in Col Names
This discussion has been moved.
-
I need to create a high level project on a detailed project that contains a number of indented rows
I have tried to create the high level project sheet using linked cells and the index function however it keeps failing to transfer the information across. I need the sheets linked so that when information is added to the detailed sheet it will update the high level sheet
-
Filter dashboard view
I have a dashboard that pulls data from 2 different sheets and various reports to give an overview of performance of projects across a portfolio. Within this portfolio, there are programmes of work (recorded as a field for each lien item). I am trying to add a filter to my dashboard, so I can report the same metrics either…
-
Update requests
Good afternoon, I need some help with sending update requests . When I send an update request via my smartsheet I want the email to be from my Own email rather than the email showing its from, for example, John smith via Smartsheet. is there a way to change this.
