-
Can I create one:many and many:many relationships between two SmartSheets?
Hello, I have two related SmartSheets covering different aspects of my data. I would like them to refer to each other so that I can ultimately pull certain aspects into a report. I prefer to use SmartSheet over SQL in order to take advantage of the workflow and approval capabilities. However. I cannot figure out how to…
-
Merged: Views/Filters - Display specific columns
This discussion has been merged.
-
Join columns from 1 match
Good evening, I'm looking for some assistance :) I've been trying to find the formula that alows me to join 3 columns value of the same line of the match. This is between 2 smartsheets. I made a quick draw of it. I would appreciate any help :)
-
Creating horizontal view for existing sheet
Hi, I'm trying to get sheet A (vertical view) into sheet B view (horizontal view). Sheet A: Sheet B: the helper column date is in txt/number so it would match sheet A. Could anyone help? Thanks. :)
-
Pulling next date from a sheet
Hello! I am looking for assistance with a formula that can pull in the next action date from one sheet to another. For context, we use sheets for customer renewal project plans. We also have a tracker that gives an overview of all the project plans and their name, completion, next action date, status, etc. What I would…
-
Workflows: copying values from one cell to another within the same sheet
Hello! I have a quick question regarding copying and inputting data. I am aware that rows can be moved or copied into other sheets via workflows. However, is it possible to create a workflow automation that copies/replicates data in "Cell A" into "Cell B"? The column properties of all the cells are set to Text/Number. I…
-
Count distinct values within cell
a
-
Automation Error
Not sure if this is the right place for an automation error or not. I have previously asked about returning a value once (not sure if my link would work for everyone or not). I was able to get it to work with a metrics sheet, a helper column, and a copy rows automation. However, the ID I used for that one, is only valid…
-
=SUMIF for calculating budget on multiple rows.
Hi! I have a sheet that breaks down different accounts. Some line items within an account will have a cost associated with it. I want to be able to calculate the cost of those line items per account. If I do a simple =SUM formula, it gets confused as things are added, changed, filtered etc. I tried to write a =SUMIF and it…
