Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please
Visit the Current Forums.
Discussion List
Age of a task (time between changes of the Status cell)
Dear Community, I am trying to find a way to automatically track time it takes for a user to switch between different status of a cell, i.e. from "In Progress" to "Completed." Activity log allows me only to see when a cell was changed and I can't narrow this search down to a particular cell. The idea is to give my agents…
Change which Email Address is used when sending emails
I have a sheet in a workspace that I want to send as a PDF attachment on a reoccurring basis via email. When it sends - it is FROM "my name via Smartsheet" and then user@smartsheet.com. I want it to come from another name - not my name. Is that possible? I assume it is if I change my name on my account it will do this…
Add the Row() Function
Please add the Row() Function. Not having that has been a huge headache for me over the last few weeks. Reason: It would probably be easier than adding vlookup, and If I can reference the row number, I can tell something to always post at the top of the page which means I can have summary math on the same page as my…
Autofill a value
Hi. I'm new at building formulas in Smartsheet. I have a numeric column that I want to autofill a 1 if no value is entered. Can someone help me with this?
Multi-Sheet & Few Clicks
I have an assessment sheet where 2 different rating columns are linked to the rating key at the top of the column. Would it be possible have the Rating Key Sheets linked or formulated so that when a rating is selected on the key, it'll enter it into the cell on the Assessment sheet? Does anyone have any suggestions / best…
Gantt view print/preview to show today's date
Is there/have you ever thought of option to show today's date in the print/preview of the GANTT chart view like you do in the main part of Smartsheet?
Collaborators cant edit cells?
I have a team account. I added another coworker as non licensed user and gave them editing and sharing privileges to a sheet. I then created a roll up sheet which narrows the main sheet down to things assigned only to them. I shared the roll up as well with the same privileges. The coworker can't edit the cells…
"Other" field to enter comments in a form?
I am a new user trying to create a survey using a form. I have multiple dropdown entries which show up as radio button on the form. Is there any way to have add "Other" to the column and provide the ability to add a comment. I searched the "Help" and "Community" and could not find this question addressed. Thanks.
Information in cells mysteriously disappears
When my smartsheet is open and I am not doing any editing, I find that cells mysteriously empty themselves and are marked as changed. The RYG balls also just disappear in the priority column and are marked as a change. Sometimes it is impossible to restore the information as it keeps reverting to being deleted. Only one…
Over riding dependency per activity without deleting the tie
I am having problems holding start and finish dates for out of sequence activities that are in-progress or completed. So if the activity is in-progress or complete and not all the predecessors have completed as planned and the dates will continue to push as the predecessor pushes. I would rather not cut the tie to hold the…
