-
Smartsheet jira connector row issue
Hi all, I have a project sheet which is connected to jira. Everytime the connector gets updated some of the rows that i have arranged/sorted get moved in smarsheet. Is there a way where i can fix the rows in one place and only the fields can get updated when the connector is updated. The locking row option doesnt help…
-
Restrict to login by ip address
Has Smartsheet got any functions to block by public ip address except single IP? My wish is to use only our local network in our office.
-
Linking the text in a cell to a document
If I have a PO # that occurs in multiple cells. Is there a way to link the PO# text to the actual document? I don't want to link the cell to another sheet. I want to link the PO# text to the actual PO document. So a team member can simply click on the link to view the PO.
-
Smartsheet App log-out/time-out
In case a mobile device is accidentally left in a public place, is there an option within the Smartsheet app that could time-out a login? Also, is there a way that a username/password cannot be saved, for this same purpose? Thanks - Dan
-
Changing Email Addresses
Hello, My colleague created an account for me while trying out smartsheet. We've since started a full implementation of smartsheet and I need to pull my old e-mail address over. Problem is that smartsheet is telling me that the e-mail address I want is in use by another account (even though I've deleted the account used in…
-
File Upload from Customer into their Designated Row
I was hoping somebody could help. I have a form set up where customers can upload their artwork directly to our sheet and once checked I send an approval request as a proof. However if the proof is declined or we check the file and it isn't print ready we require customers to upload a new file (artwork). I have tried this…
-
Cashflow formula - IF formula issue under date formatted column
Hi, I'm trying to create a project cash flow projection sheet and I'm stuck with the (see attached photo) IF formula. I need the column to be formatted as date to find the IF formula but I cant format the cells below as number/text and I believe this is the reason that the IF formula isn't working. Any help to get this…
-
Profile Settings Mysteriously Changed?
How do I change my settings to stop overwriting cell content and default back to 'insert'? I used to be able to just type over something, but now the contents are overwritten. For example if I have "There is 90% in this." in a cell and I want to update it to 95%, it will now write over the '90% in this." completely instead…
-
Shift license and owned sheet at same time to new user
I have 6 licenses and 6 licensee's and want to transfer a license to a new person from a current person and transfer the owned sheets to the new person. Problem is that the license needs to exist with the new person to give the sheets to that person, but i can't give them the license until i move the owned sheets. I hate…
-
Transfer a folder's ownership to another account
Hi, I have recently recieved a licenced user with my company mail account and I would like to transfer all the work I made with the trial version user (which is related with another mail account) to this new one which is the official. Is there a way to do this directly and not creating and sharing workplaces stuff? Another…
