- 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…
- Limit increase: 500,000 inbound cell links
Hi Community, Now all users on all plans can add up to 500,000 inbound cell links in their sheets, allowing you to consolidate information by linking cells between sheets. Learn more about cell links. Catch up on how Smartsheet is investing in scale and reliability by reading VP of Engineering Gihan Munasinghe's recent…
- Linking two sheets into one master sheet
Ok Here is what I got, I have two employees who work for purchase import section. From Rising the IPO to having the LC created to have the goods delivered to the factory. I have created a common grid header for each of them and they are populating it as I write this. I will then create a master sheet where I will put in…
- 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": {…
