-
How can I update data in one sheet from another sheet?
I have a New Hire Master sheet to keep track of our New Hire's onboarding tasks. The first eight columns contain data that needs to be pulled from the New Hire Master Sheet over to the Membership Tracker sheet. I'd like to use a formula to update the the 8 columns in the Membership Tracker with the latest data that is…
-
Need a better Sheet Summary Formula - (Collect/Max & Index/Match)
In my example, I am able to return the top Sales for an item based on certain criteria for a Sheet Summary formula (Shirt Top Sales) with =MAX(COLLECT(Sales:Sales, Product:Product, "Shirt")). I am also able to return the Color for the Top selling Shirt (Blue) with a formula using the previous summary value in the formula:…
-
Why is sheet adding rows from dropdown list?
Hi, My sheet is adding in new rows based on my list of dropdown selections. I added in some suppliers in a column which we may use in the future but currently do not have rows in my sheet. However, the sheet is bringing them in as new rows with that supplier name even though I am not asking it to do anything. Do you know…
-
iOS App - COPY Rows
In the iOS app, you can cut and paste a row, but you can't copy and paste. Not sure why this is. Having the ability to copy and paste rows would be extremely useful when working on the go and data needs to be duplicated.
-
Why can't I access the workflow automations on a sheet that was shared to me?
The sheet owner already made me an admin yet I still couldn't open the workflow automations tab (I can access the forms, edit the columns, rows, cells, and etc.) I have good network connection and I already tried refreshing the tab several times. They even removed me then added me again multiple time but the same message…
-
Modified system column questions
Does Conditional Formatting trigger the Modified time stamp? I have a sheet that I want to highlight entire rows to a certain color if the Modified date was in the last 30 days, but every time I save the sheet the modified date would update to whenever I "saved". This is really a terrible design if it does. Also, it looks…
-
Can you use Groups in Contact list column type?
We have different groups created under user management, for example, email team, marketing team etc. I wanted to know if they can be used inside a column with contact list column type for a project? If yes, how? If not, what exactly is the use of creating these groups apart from workspace, sheet sharing?
-
COUNTIF Formula Returns Zero in Sheet Summary
I have a very simple COUNTIF formula that isn't working in the sheet summary section. For example, I'm trying to count how many times the year "2017" appears in a column called "Tablet Year". The formula should be: =COUNTIF([Tablet Year]:[Tablet Year], 2017) I've also tried surrounding the "2017" in quotation marks in case…
-
Dashboard Sheet name Hyperlink proposal
I have a dashboard with a summary report that shows all my records within my Smartsheet, within the report i have the sheet name column which acts as a hyperlink and takes the user to the associated sheet where the record is located. The problem is the link takes the user to the page but leave the user having to go and…
-
Sheet Relationship Diagram
Is there a report I can create that will identify and map out all of the sheets that are linked to other sheets? We have hundreds of sheets, and quite a few workspaces. We regularly link one sheet to another so they all stay updated, but it can be hard to capture where everything is linked. For example, we have a resources…