-
Can I make the column title an image?
I am organizing social media posts and would like to have the name of my columns be the logo of each social media platform. When I have a posting, I want to be able to log by checking off each platform it was posted on. I can only figure out how to put text in the column title, but think it was be visually appealing to…
-
Self-populating formulas in rows
Why don't the formulas instantly populate the next row? This is extremely frustrating. Sometimes, the self-population or smart population of formulas will occur in proceeding rows, and the other times, it won't. Is there some sort of trick or process to make sure this happens every time? Thanks in advance for any help with…
-
Hours tracking conundrum
Hello, I'm a new user who has completed my 1 month trial and had a 30 min session with a SS expert. However, I still haven't figured out how to make SS do what I want it to do. Specifically- I work for an 8 person consulting firm with an average of 70 clients at any given time. Sometimes one consultant works with one…
-
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…
