-
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…
-
Formula for averaging days
I have two columns I am using for this formula: "Date Received" and "Days Duration (Received to Listed)". I want the formula below to look at any items in the Date Received column between 1/1/25 and 1/31/25 AND where there is a number in the Days Duration column (some columns have errors from time to time and I want to…
-
how to add months to a date?
Hi team, I'm trying to add X months from the yellow column to a date and get the result. for ex: 01/01/2025 + 12 Months = 01/01/2026. Is there any way to do so? Thanks in advance!
-
Weekly rotating roles formulas
Hello, I am trying to create a report or calendar sheet with these weekly rotating roles: Weekly 1st shift Call Center (Mon-Sun) Weekly 2nd shift Call Center (Mon-Sun) Weekend On-Call 1 (Sat-Sun) Weekend On-Call 2 (Sat-Sun) I have a sheet with the list of [Name]s and a [Resource #] column to use for creating the rotation…
-
CountIF contains name from a contact list help needed
I have a column that is a contact list where a single or multiple staff members can be selected to be scheduled. I'm trying to create a formula that counts how many times each individual's names are listed as a scheduled staff member from the contact column. The formula I came up with only pulls results if that person's…
-
Dashboard Help- COUNTIFS, Checkboxes and Hierarchy
I am trying to make a widget for a dynamic dashboard that shows how many child level 2s and if the "Closed?" box is checked or not. I would like to make it a pie chart if possible. The level column is measuring by Parent/child hierarchy with the formula =COUNT(ANCESTORS()) + 1 Thanks!
-
IF/OR Formula Issue with writing
Hi! I'm trying to figure out a formula for an IF/OR situation. Basically -- if the [Add-ons] column includes the tag "Prebill," I want the [Final Invoicing Amount] column to be "[Total Project Cost] - [Prebill Actual Invoiced]." If it's NOT tagged "Prebill," I want the [Final Invoicing Amount] column to be "[Total Project…
-
Trying to collect data from a sheet where a person assigned is one of multiple contacts
Hi, I'm trying to revise a formula and am a bit stuck on how to do it. I would like to pull resource utilization information from my Project Plan into a Team sheet (and no, we don't have the Resource Management module or Control Center at my organization). Here is an example of the current formulas I'm working with:…
-
IF(And = I have tried this several times Could anyone help
I need to update a value in a new column. How would I look at a date column that shows dates between 01/01/2025 to 03/31/2025 and place the value of Q1_2025 into another cell? Q1_2025 is working as it should. The others do not. I tried doing one quarter at a time; however, I still get a message that it is incorrect.…