-
PLEASE HELP ME! Formula question
I have a budget request sheet that requires two approvals - first approval can be one of two people, second approver is always the same and only used if the request makes it past the first approver. I am trying to get "Status" to update with Approved or Denied once the approval have been submitted. I can get it to work for…
-
Assistance with IF AND Formula
Hello, I am trying to create an IF AND formula and get stuck after a certain point as I am a bit green when it comes to Smartsheets. What I am looking to have it accomplish in general terms: IF the status is set to High AND the Status is marked as Complete, then input Today's date in the Completion Date column. Can someone…
-
Cell linking broke my sheet!
Yikes. I was trying out the cell linking feature now my sheet is messed up and tells me to log out and back in. I tried to delete the linked cells and save but it won't let me. I can't save or publish. I can't revert..... Reached out to support but hoping someone can help fix. formName: ajax formAction: fa_gridSave…
-
Can I link an entire sheet into my master sheet?
It looks like I need more than Cell Linking in our master project tracker. Do we have the ability to add a section on our master sheet so that any updates from a separate MARKETING TEAM sheet is displayed in the master sheet? I'm afraid simple cell linking only focuses on cells and won't take into account additional rows…
-
Auto move a Sheet after x# of days of inactivity
Hello, is there a way to set up a workflow or some automation on a sheet what would move it to a designated folder and remove all share permissions after some # of days of inactivity? As an admin, I have a lot of sheets stacking up and would like to either start setting them up with this auto move or have some way…
-
Login and toggling between sheet very slow
Just wondering if anyone has experienced similar issues, on login we are experiencing very slow response time, once logged in we are also experiencing delay when toggling between sheets. The curious thing is that this is only happening on one of our computers (iMac) the rest of the computers do not experience this issue.…
-
Bulk Upload of Contact Profile Data
I know I can bulk load contacts into Smartsheets for my account. But is there a way to upload full profiles? If so, what's the CSV format and where do I do this? Or - Asked a different way - If I include all of the contact info in the CSV file, will it import all of the data? Or only the "First Last Name" & "Email…
-
Question regarding guest accounts
Hi All, I am a member of my organizations IT Support team and I am currently researching an issue reported by one of our internal users: We have a user outside of our organization that has been invited to work on some smartsheet documents with some of our users. I believe this is through a guest account that was given…
-
Publishing only filtered list to google calendar
I'm having an issues with "Publish to Googgle Calendar". Every time I've publish some task in google from SamrtSheet, SmartSheet publishes everything in my Google calendar instead of publishing the specific tasks assigned to me. I've attached a detailed description of the issue I'm facing with screenshots. Does anyone know…
-
Formula Confusion!
We are trialling smartsheet and overall enjoying it so far however we have run into a bit of brick wall and any help would be appreciated! We have a main sheet with all our orders on it, using an older version to muck about with layout at set up at this stage hence the old haulage dates! Each order has details of the sizes…
