-
Check box - how to auto record user details once selected
Hi Guys, I am using a checkbox to indicate when a particular task has been completed, but i need it to automatically record the user who changed it and when this occured. Can anyone help me with this, or suggest another way to make this work. Thanks in advance, Brett
-
Find & Replace
I did a search in the community posts, but was not able to find an answer to my question. Please forgive me if I somehow missed it. One of the features I sorely miss in Smartsheet versus Excel is "Find" and its companion "Find & Replace". I use them daily in Excel and while I know you can filter columns in Smartsheet, it…
-
Feature Request: Search Both Sheet Name & Content Simultaneously
I'd love to be able to put both sheet name and content string into the search box and it find what I'm looking for. For instance... We have a sheet named "UIN" that has our store names and unique store numbers. I'd love to be able to search UIN Woodway and it find the cell that I'm looking for. Right now, I have to search…
-
Paste in Visible Columns
Hi, I am looking for feature that's available in excel. I have to copy-paste from one sheet to another. I am copying from colummns 3 consecutvie columns - A, B, C. Pasting in A1,C1,D1 (where B1 is hidden). When I paste it, column A gets pasted in A1, B in B1 and C in C1. Where as I would like it to be pasted in A1,C1,D1.…
-
Formula to check percentage total
Hi I have a sheet which is pulling through some data from other sheets via cell links. The cells are being pulled from a Project Plan (with rolled up section totals). Based on this data, I want to set some conditional formatting on my sheet. I have: %COMP STARTDD ENDDD 55% 10/08/16 22/08/16 I'm using a formula (hidden…
-
Track changes
Hi there, I am wondering if it is possible that when changes are made, for example after changing dates of tasks and phases, that when Smartsheet saves this, it would save leave the old file there for an audit trail. For example, I change the dates of five tasks, when I click save - I'd like this to be v2, and then each…
-
Send Row / Update Request Enhancement
I utilize the Send Row and Send Update Request quite a lot and I always customize the columns that I need to send. The majority of the time, I utilize the same columns and need to customize it every time. It would be helpful if the user could save a few different templates to choose from. Please let me know if I can…
-
Contact Database
Hello! I'm new to smartsheet. I was wondering if there was a way to click on a company name and have it display all of the contacts associated with that company? I understand that you can link cells and link sheets but I don't want to create a sheet for each company. We have hundreds of companies and hundred of contact…
-
Linking cells based on matching criteria
I have two sheets, both sheets have a row of column IDs, I would like to dynamically match the column ID from one sheet to the other sheet and then update a row. Similar to the new Lookup fucntion that was recently released but across two sheets. Has anyone developed a solution for this. My only option is to manually link…
-
Sending auto update request based on % completion
Hi, I want to send update request automatically to shared users of that particular sheet after the % completion column is 100%. Please guide me, how it is possible. Thanks.
