-
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 = ???,…
-
How to get symbol to automatically update in destination sheet when it updates in the source sheet
I have rows copying over to a new sheet whenever column C is a certain name the box in column J is checked. Source sheet: Destination sheet: I would like a formula to automatically update the symbol in column L of the destination sheet to match the symbol in column M of the source sheet when the rows of columns A, B, C, D,…
-
How do I score out a survey and have it populate in another column?
Hi everyone , I am attempting to create a scoring system for a survey based on this type of scoring below. These are the survey questions and it already built in a sheet. Thanks in advance for the support.
-
Time-Based Automated Workflow where date field is linked from separate Smartsheet sheet
I have a summary page that pulls in key dates from other sheets. I set up automated workflows based on those date fields, and found that they don't run (I assume they don't recognize the data in the date fields). This feature would be extremely useful for me. Is it something that would be considered?
-
Can you Log a Cell In time?
Within my project sheet I have formulas set up to show me the present of Target duration vs actual completion date. The parentage in cell will change as we close out projects. Is there a way to track/Log this cell as it changes so that I can create a line graph to see our patterns over time?
