-
Combine Contacts from multiple columns into a single cell
Allowing contact columns to be combined into a multi-select contact column would make team management and index sheets much more useful. If Columns 2 through 10 on my sheet are all contact columns, a formula like =Contact2@row + Contact3@row + Contact6@row should produce a multicontact cell, not a text cell. That would…
-
PROPER Function
Hi! I wanted to submit a feature request to add to Smartsheet. I organize a lot of documents that are displayed in all caps [Ex. PLEASE SUBMIT ADDITIONAL NEEDED DOCUMENTS]. I have noticed there is not an action/formula available that changes the text to PROPER like in excel [Ex. Please Submit Additional Needed Documents].…
-
How Do I Return a Status/Name From a Different Sheet within a Project in Sheet Summary
Within each project we utilize Sheet Summary to pull into reporting and ultimately dashboards. There are a couple fields that I would like not to be manual, but instead use some kind of formula if I can. The issue is that the formula would have to pull the name/status from a different sheet (I noticed there is a reference…
-
Add months to a date
Hi Team, I need to create a formula to add X months to a date (X) to calculate a due date. Any suggestions? Thanks in advance!
-
Fomulas and automation
Hi Everyone. I have a rag status column on my Smartsheet which is determined by a formula, so as the task becomes due or overdue the rag status updates from green→amber→red. I'd like to receive a notification as tasks transition to amber/red. I created an automation, based on the change of rag status, but it only triggers…
-
COUNT IF Certain Project Category, resource and in Current Month
Hi! I am trying to create a sheet summary formula for each team member which shows the total files they have with a consultant in the current month. We generate a new sheet each month so i only need it to count after 1st of the month. I can't even get just a basic number of all projects with consultant after the 1st of the…
-
Dashboard Help- Widgets and COUNTIFS
I am new to Smartsheet and making a dashboard. I want a widget to show as a pie chart illustrating how many : 1. "SRM"(child rows w/ purple check marked and bold text) there are [see screenshot below] 2. if it is "closed"(box checked) or not. I know I need to make a separate metric sheet with a COUNTIFS formula referencing…
-
The result of index and match formula is wrong
I have a material number and material description in the source sheet which I want to use match & index formula to identify the material description in another sheet, I use this formula: INDEX({Test Item Database Range 4}, MATCH([PCX Supplied Material#]@row, {Test Item Database Range 2})) However, the result starts to…
-
change cell value with SUBSTITUTE formula
Hello! Trying to change the column (submitted by) values from user name to the actual persons name. I have: IF([submitted by]@row="{users log in}", SUBSTITUTE ({first and last name})) I'm getting no return value. thank you
-
Excel @Text() Functionality in Smartsheet?
Is there a way in Smartsheet to use a formula that gives the same result as using @text() in Excel? I have a spreadsheet that I need to concatenate several fields together and have the field then display as text. Most of what I see now for formulas is to covert from text into formula. But I need to go the other way? Use…
