-
import and consolidate daily changed excel file with SS sheet
Hi, currently my team (4 members) uses one excel file to save information about insurance incidents (task tracking with regularly action documentation f.e. what have craftsmen done, has insurance paid a.s.o). It takes a few month until we all may use SmartSheet. Until that time I would like to daily or weekly import the…
-
INDEX/MATCH Formula
Hello! I'm creating a document where I would like to index a column of dates, and return a specific date from that list. I need one of two things to occur: 1) If a date occurs in the upcoming week, I would like to return the latest date of the week 2) If no date occurs in the upcoming week, I would like to return the…
-
Connectivity Issues
Dear Smartsheet, I love you. I really do. But these constant connectivity issues are making me think I need to find a different solution. Yesterday I was trying to demo the wonders of your application but could not connect. And again today. The frequency with which the application is unavailable has me concerned.
-
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…