-
Synchronizing data from Microsoft excel into an existing worksheet in smartsheet
Hi everyone, i recently uploaded a file from excel and linked it to an existing worksheet in smart sheet. The file in excel is updated every week. Is there a way i can synchronize the file with smart sheet without having to upload the file again every week.
-
Pulling email from other sheet when corresponding business name is entered
I have a sheet with the name of a business and the corresponding contact emails for each business. In another sheet, I would like for the name of the contact to populate when the corresponding business is entered on the same row. here's what I've tried... =IF([Name of Business]@row = {Recall Business Contacts final Range…
-
Disappearing Formulas in Locked Column
I have a locked column with a formula used for a calculation. The formula is dragged all the way down. The formula keeps disappearing within blank cells. The activity log says it is changed by cell link. I keep dragging down the formulas and saving, but it just resets again. Any ideas?
-
Have a specific cell auto increment up as a new number is added
Per the example below, column "Total UG Footage Complete", I would like have the cell with "50" in it auto increment up when the box is highlighted and I added another 50 for it to show 100. Can that be done?
-
Form start timestamp
I've created a web form that will be heavily utilized. Managers are wanting to conduct a transactional analysis to see how long it takes the worker to complete. I'm looking for a way to capture the current time either when the form was accessed or find a shortcut to copy from the operating system and paste into the first…
-
Calculate new start time for whole schedule
Hi there! As an event organizer, I want to automatically update my schedule in smartsheet when a session takes longer than expected. Column 1: Start Time (HH:MM) Column 2: End Time (HH:MM) Column 3: duration in minutes Column 4: new start time (HH:MM) how can I arrange a formula so that once entering a new start time in…
-
COUNTIFS with NOT CONTAINS from a Referenced sheet with two columns selected
Hello! I've searched through a few community posts but cannot seem to find an answer to my formula I'm trying to calculate how many products we have in one column that are not "done" from another column that are both being referenced from the same sheet where: {product} = Product1, Product2 {status} = Done, Ready for…
-
Multiple index/match nested in an If statement
Hello, I am having some issues with the following formula not returning the value I am expecting: =IF(CONTAINS([Raw Lot ID]@row, {ActiveRawLot}), (INDEX({ActiveQCResult}, MATCH([Raw Lot ID]@row, {ActiveRawLot}))), IF(CONTAINS([Raw Lot ID]@row, {ArchivedRawlot}), (INDEX({ArchivedQCResult}, MATCH([Raw Lot ID]@row,…
-
Formulas not processing for ages
This is a weird one, and it's been happening for some time. I have a sheet that people add to, in a batch copy and paste style. There are a few columns to the right of the batch data that process the cells and gleam certain information. It's nothing resource-intensive: e.g. in one cell we might have a person's team and…
-
Help with nested IF AND statements
Hello I'm new to Smartsheet and looking for help to convert a really long excel formula into Smartsheet. Is there a maximum number of nested statements? I have pasted it into Smartsheet as is, and get the Unparse error. Essentially, what I want to do is display specific text when two criteria are met. My formula in Excel…