-
Copying and Unlinking Cell Data
Good morning, I have a master list of all of our projects comprised of linked cells from our project schedules -- so it updates as the projects update, providing a summary status overview of the percent complete on all projects. I want to track our progress month-to-month to determine how much progress was made during a…
-
Baffled......Circular / Blocked Reference (Vlookup)
This one is baffling. I have a problem with 2 sheets reading each others data through a Vlookup. Each sheet has Vlookup ranges from the other sheet. I understand why formula and Vlookup may return a #circular or #blocked reference, but I don't understand why my sheets work perfectly for periods of time, and then start…
-
Functionality of dashboard with Forms on it
Hi, Created 3 forms for doing employee reviews with underlying grid sheets. 1 form is an Employee Self Review, 1 Form Employee Selection, and 1 Form Reviewer Form. Idea is a employee fills out self review, then sits with manager. Manager opens dashboard, selects Employee from Employee Selection Form, then clicks submit.…
-
COUNTIFS returning 0
I am having an issue with the formula below. I am attempting to get the count where the year of {Conv Rec 020} equals the cell "2020" and the month of {Conv Rec 020} equals 1 (aka: January). I have quoted the 1 and get the same results. The formula is returning "0"... any thoughts to return the correct values? It should be…
-
Filter View Access for certain users
Hi everyone, I am using Smartsheet to implement an AM (additive manufacturing) order tool for a SME, which uses AM for prototyping. Objective of that project is to directly set an order out of the CAD programm (STL-file, part specifications) into Smartsheet, which will automatically send a notification to the supplier, who…
-
Feature request: Hashtags to create automatic reports
Hello! So, the story is: Our team is using a Smartsheet workspace to coordinate the production and deployment of assets of an entire Content and Marketing department. We have created sheets for each type of process/asset (Social Media, Video, Print, Web, Email Marketing, etc), automated formatting in all sheets according…
-
IF Function (related to dates)
Hi @ all, I have a formula issue where I would like to get your help. As you can see I have a delivery cell which I would like to link to my "Financial Year" cell based on the following condition: FY2020 = starting 01.01.2020 until 31.12.2020 FY2021 = starting 01.01.2021 until 31.12.2021 FY2022 =starting 01.01.2022 until…
-
Sum of Totals by area and Date
I am trying to set up a formula that does the following: If in Work Log A, the Plant is X and the date range is between 10-1-2020 and now, what is the total cost of this time range for this sheet? I also want to break down by monthly range: If in Work Log A the plant is X and the date range is between 1-1-2021 and…
-
Excel Data Extract
Who has experience with Zapier (or another app) that will allow Excel data extract into an existing Smartsheet? Need more functionality than just whole rows. Too complex to accept creation of a new Smartsheet with each Excel data transfer. Data Uploader won't work. Would like to be able to extract individual Excel cells…
-
Convert formula to column formula without losing existing cell data
Hello, I have a sheet where I'm trying to add a formula as a column formula so that it applies to new rows, the issue is many cells in the column already have data (Date column) that I don't want to lose. The formula is an INDEX/MATCH that is referencing another sheet to obtain a modified Date. I have a trigger to copy a…
