-
Auto-generate date/time field data based upon existing column
I have a sheet where I have a Status column. When I chose "complete" in that Status column, ideally I'd like to have another column (let's say it is named "Completion Date/Time") to auto-populate with the date/time (preferably just time) that "complete" was chosen from the Status column. This seems like an easy ask, but…
-
get list of projects worked within last month (without helper fields)
I have a task list that includes what project the task belongs to. The project field is filled in manually (not a preexisting list). I would like to setup a dashboard to show a distinct list of projects that had been worked on, how much time was spent on them, etc. Where I am having trouble is how do I get a distinct list…
-
Transferring ownership of Workspace easily?
Is there a way to transfer ownership of a workspace without having to remove the current owner from the workspace? They still need to own specific sheets, and edit others in the workspace, but do not need to own and administer the workspace anymore.
-
Toggle Hyperlinks
I have a need for a cell to hyperlink to different URL's based on whether or not the logged in SmartSheet user's email address (i.e., SmartSheet ID) is internal (i.e., works for our company - e.g., tim@ourcompany.com) or external (i.e., one of our customers - e.g., bill@clientcompany.com). Is there a way to do that via a…
-
Move row API not working
We use move row API since 12 hours ago it has stopped working
-
Convert numbers to text & concatenate
Hi all, I'm new to Smartsheets and hit a bit of a wall. I need to put task due dates in a 30-60-90 designation. That 30-60-90 is set one time at the beginning of the month so it's not dynamic. I thought my best bet would be to build a column designated YYYYMM to do any month math for the rough 30-60-90 column. I figured…
-
Can Pivot Sheets shared or embeded in iFrame?
Just try the Pivot Sheet in the smart sheet, that is the something I am looking for. But whether it can be shared or embed in wiki. Which I don't need to export the result and do the analysis in the excel?
-
Licensed User to send an email for a row?
Do you have to be a licensed user to email a row? If that was one of the "new" changes for the unlicensed user, I did not see it in the email.
-
Prioritize/sort rows (possible feature request)
It is possible to drag 'n drop rows to change their order, but if you order by some column this "index order" is lost. I need some way to prioritize rows, with the most important at the top. I can do this by adding a column of type number, and manually enter the index for each row, but this is rather cumbersome. What I…
-
Auto Lock columns or rows through formula
I want to know if it's possible to create a conditional formula (or something like that) that as a result Lock the row or the column. When the user's filled the entire row I want to lock it from other changes, automatically.
