-
Multi-select dropdown column to pull single value in another column
Hi Everyone! I need some assistance with a formula to extract single value from a multi-select drop-down to individual columns. I got most of the process to work but for whatever reason the formula for control 4 column ends up displaying a incorrect number "12." instead of "12.1" and control 5 column displays the whole…
-
Contact Field Listing Multiple Contacts to Feed Individual Rows in a Report
Is it possible to parse out a contact field with multiple contacts into a report or new sheet listing each contact on its own row? If that is not possible, can you do the reverse? I hope this makes sense.
-
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…
