-
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.
-
Why smartsheet require login for published sheet?
Previous embed the smartsheet in the wiki by iFrame, which is published link , it doesn't require log in. But now it required log in, it is really annoy. Any way back to original way?
-
Sheet Summary cell reference changing?
Hello, I have built a sheet summary with formulas that look something like this, =COUNTIF(Provider1:Provider154, "Syringa"). The problem that keeps happening is that the cells I referenced to count, are changing randomly. For example, I will reopen the sheet and the formula looks like this, =COUNTIF(Provider24:Provider75,…
-
Dropdown Form Entry
I want users to enter data via form and one of the fields is a dropdown list and I do not have the restrict list to values selected. I want people to be able to submit new entries via the form but it will not accept any that are not already pre-defined in the dropdown list. This seems like a defect to me. People can add…