-
Getting data OUT of Smartsheet into a form
I am wondering if and why Google seems to be the only way to get data onto a form for customer presentation? In my scenario, I am trying to get a few cels onto a customer view of a quote. I still want to use Smartsheet to perform the calculations and record of, I just need to send a customer a quote.
-
Join and Collect Function with Hyperlinks
Hello All, I got my function to work the way I wanted it to, but it did not keep the hyperlinks when it gave me the values. Is there a way to keep the hyperlinks or add them back when using Join(Collect())? =JOIN(COLLECT({Sandbox - DR - Deliverable}, {Child SKU}, =[Child SKU]1, {Sandbox - Delivery Readiness Tracker Range…
-
Dependencies for drop-down menus
Hello, How can I create a drop down menu dependent on value selected on the previous drop-down menu? Thanks Laura
-
Date Fields
I have two date type questions: Question 1 I am looking to auto populate a date field as soon as two other columns are populated. I want the date to remain fixed and not change to 'today' every time the spreadsheet if opened. The Columns Are: Date Part Fitted - this needs the date auto entered when: Part Number Fitted…
-
Cell linking effecting Last Modified date for whole sheet
I have a Main sheet with a cell that is linked to a log sheet to count total rows. whenever a form user adds a row to my log sheet it is updating the last modified date for all the rows on my main sheet. any idea how I can have this stop happening so I can send out a notification for any row that has not been updated in…
-
Email content
Hey guys, Hoping someone can help me out. Im trying to see if there is a template or a way to create a tab that lets you upload email content i.e. a content image plus word doc/text to a certain newsletter and the person who is looking after that newsletter gets a notification when content has been uploaded. Also the…
-
VLOOKUP data type question
I'm using this vlookup formula to pull back a value from a data sheet. Let's say the value of NUMBER81 is 123456 and when I type in the formula on the desire sheet it returns "No match". When I go to the ACCOUNTS sheet and look at the data there is a value equal to 123456 in Range 1. When I put an apostrophe in front of…
-
Is there a way to display elapsed time for a project?
Hey everyone! I have a project which has the obvious "start" and "end" date columns and Smartsheet automatically calculates the actvity duration. Is there a formula or something which will calculate and display "elapsed" time from start based on the current date? Thanks! Steve Stutz
-
Auto Populating Report or Sheet with New Rows from Master Sheet
Hello- I'm trying to figure out how to automatically pull in new rows (either using cell linking or reporting) from one sheet, while having columns editable from another sheet. For example, I have one sheet that is a master list of all projects in my organization. We continually add new projects to this sheet. Each project…
-
Consolidating several smart sheets in one (appending columns)
Hi. I have several smart sheets with 2 columns, being the first column common to all. What is required is to have an aggregated smartsheet with the common first column and append the second columns of the other smart sheets. I.E Smarthsheet 1 Subject Juan math A physics B Smartsheet 2 Subject Peter math A- physics C…
