-
Increment previous row by 1 using column formula (when condition is met)
Hello Smartsheet Community, Looking for what should be a simple solution here: ultimately need to increment count by +1 once a new Project name is entered in a new row. If there are 8 Items within a Project, they will carry the same Project Count value, until a new Project is entered, after which Project Count increases…
-
What's the best way to have several photo upload sections in smartsheet?
I've been asked by our superintendent if Smartsheet is capable of having a form with the below information: Supplier Invoice Picking List Number Container Open Door Photo Container Number Photo Seal Number Photo What is the best way to capture this information in a sheet/form? Thanks in advance :-)
-
Count when 2 Conditions are met
I have a field called Status & a field call Health (using RYG symbols) This =COUNTIF(Health:Health,"Green") counts the symbols correctly. But I am trying to count Status "Open" that have a Health "Green". So I tried using COUNTIFS… =COUNTIFS([Health:Health],"Green",[Status:Status],”Open”) Gives #UNPARSEABLE 😕 Can anyone…
-
certain cells remain locked until specific data is entered in another cell
I would like the ability to lock not an entire column or row, but just a single cell, and then unlock it when data is added to another cell. The solution could be implemented as a workflow.
-
Team Member Contact shows as email address
Hi all, One of my team members was invited to our Workspace (before I came on board) with his contact name as just email address, while everyone else has "Name" then email address. In our ticketing sheet, we use an Assigned To column that is a Contact List and his name shows there but when I run a workflow to automatically…
-
Timelines - multiple work streams
We need to collect, and summarise timeline info in several streams a) Activities by group, relating to their workstreams (seasonal busyness) b) Org wide activities (i.e.long term and annual plan etc), c) External factors relating to staff availability (school holidays etc) This is to aid in selecting best timeline to…
-
How to capture the Name of the person who changes the column value?
Hi all, I'm trying to to capture the name of the person who does the final change in a material release in a process. Please see attached. The goal is to have the name of the person who clicks release (which is the final progress status). Do I need a formula for this? I used created by option in the sheet. Not sure if…
-
シートの「列名」と「列の説明」を抽出したい
こんばんは。いつもお世話になっております。 使用しているシートの「列名」と「列の説明」を簡単にエクセルへエクスポートすることはできないでしょうか。 「列名」は「シートのエクスポート」操作で抽出できるのですが、「列の説明」を一つ一つコピペするのが大変です…。 何か良い方法があれば教えてください。
-
Remove smartsheet email in mod by column?
Hello, Simple question that im guessing is no but is it possible to stop or remove the automation@smartsheet.com from showing whenever an automation happens? I have a modified by column and it doesn't really do anything if it always says automation instead of the actual person who modified it.
-
From ESRI GIS to Smartsheet
I came across many articles regarding connection from Smartsheet to GIS, but I'm interested in getting attributes out of GIS and into Smartsheet. We have many program administrators need information from GIS and manipulate it to create and track projects.
