-
How to use COUNTIFS where there are 3 conditions (columns to be referenced)
I'm trying to create a formula in a metric sheet that is referencing another sheet where data is held. I've been able to set up a COUNTIFS formula that references 2 columns so far, but my issue is that it doesn't seem to let me reference a third column using the "formula builder" as below: I'm trying to use COUNTIFS to…
-
Column Headings and Linking
Hi Guys A quick question (if there is such a thing); when adding a link from one sheet to a cell in another sheet do the column headings have to be the same? My assumption would be they don't, I imagine the column name 'internally' is irrelevant and there is an underlying system generated reference, otherwise changing a…
-
When a copy row automation is triggered, is there a way to only copy certain columns/cells?
When a copy row automation is triggered, is there a way to only copy certain columns/cells in that row? I saw in a post from 2020 that this was not possible yet. Is this possible now in 2023?
-
Cell Value Capture for Monthly Reporting
Hello, I am trying to build an executive summary dashboard and would like to capture cell values at the beginning of every month to compile on a monthly basis. I have thought about using a row copy automation however i need to build a "capture sheet" for the dashboard to reference for several data points (total invoice…
-
get cell value from one sheet to another based on ID column
I have three grid sheets A,B,C in sheet, A I have two columns as follows: in sheet B& C, I have the same two columns. I want sheet B to get the status value if the status changes in C Also, I want sheet A to get the status value if the status changes in B is it possible to achieve this using Vlookup or any other method?…
-
Multiple Location in One Intake Sheet for one project
Hello All, We will have one project that will have multiple locations (that has other information such as num of people, city, country, name etc...). Since we have one intake sheet and as the new project comes in, new rows gets created. Our current solution is to create just a separate location sheet where folks can go and…
-
API PUT and Body help for Cell link from a cell in sheet "a" to sheet "b"
I am having trouble linking a cell from sheet a to b. I am new to using API and possibly just getting the call wrong? or the body. Any help would be appreciated. PUT: https://api.smartsheet.com/2.0/sheets/4098048888098692/rows/1370574824361860/cells/259016080 Body: { "cells": [ { "linkinFromCell": {…
-
Conditional Cell Linking between a sheet and a form
Hi, I have created a form in Smartsheets which has different logic, depending on the user's response specific questions appear, and user inputs specific information. This gets created in a sheet in a different set of columns. Reading this table which is directly being populated from the form can be difficult as one has to…
-
Cell Linking Default in New Rows
Hi! I have a sheet with hyperlinks to training documents. I have another sheet which tracks when the training is completed for each person. I'm currently cell linking the training document to the other sheet but I need that cell link to be the default value when a new row is added. I tried VLOOKUP but only text appears and…
-
IF AND Statement for Color Statuses
I am trying to do something that I thought was fairly simple, but I keep running into an issue and receive an "#Unparceable" with my current formula. I am trying to build a Task Status based on Red, Yellow, Blue, and Green Circles. My challenge is getting the proper formula/syntax for my Yellow Status. =IF([Status]1 = ???,…
