-
Publishing Data
Hi All, I am currently on a Pro license that doesn't have the publish feature. I have in mind a project for myself where I would like to combine several reports that I have set up that track current market dynamics and are "published" once a month. Below are some key points that would need to be incorporated. I'm hoping to…
-
Copy cell value from one sheet to another
I have a form that feeds into a Project intake sheet. I want to be able to copy the number entered in one column (Project ID) into a column(Project ID) on a different sheet Project Metadata. Screenshots of the two sheets are included:
-
MAXIFS - can't find alternative
I have an formula I'm trying to translate from an Excel sheet to Smartsheet. As MAXIFS does not seem to be supported, I've tried a few other suggestions I found in the community board and can't seem to make it work. I need the formula to look to see if the Program matches and the Model Name matches, and if so return the…
-
Project Plan - RACI Formula Automation
I have a Project Plan template that will be customized for each client each time it is saved as new. At the top we've included a Stakeholder list (Exec Sponsor, PMO Project Lead, Program Lead, & SDC). I'd like to automate the RACI columns in my Project Plan to correlate with the stakeholder list. The roles themselves…
-
If formula with greater/less than
This is probably a fairly basic question, but I'm having trouble creating a formula saying "IF the value of specific column is less than 45 then make column say YES, and NO if greater than 45"
-
Status formula pulling from 2 columns and using multiple conditions
Hello, I am trying to write a formula that pulls from two columns: Progress and Done? Progress is a drop down column with these options: Not started, In progress, Scheduled, Declined. Done? is a checkbox. When Done? is checked, then the formula should return Complete. When Done? is unchecked and Progress is Not started,…
-
Formula COUNTIFS, AND, DATE help?
I'm having trouble getting this formula to work trying to return a sum of classes based on timing (Quarterly). I'm getting the #unparseable error. I did get it to work for one quarter: =IF(Today@row = "Q2", COUNTIFS({Grad Date}, AND(IFERROR(MONTH(@cell), 0) > 3, IFERROR(MONTH(@cell), 0) <= 6), {Grad Date},…
-
Sum Children not working
I cannot get the parent row to sum anything except direct children. If them children have children, it is not including this in the sum (see screenshot).
-
IF formula #Unparseable error
Hello! I have set up the following IF formula that triggers actions based on risk category, but it is returning an #Unparseable error. I would appreciate any help anyone can provide. Thanks! =IF(CATEGORY@row = “Resource”, “Escalate”, “Do not escalate”)
-
Cross sheet formula
I am new to Smartsheet and am struggling with a basic formula. I am simply trying to multiply a value from in a specific cell from one sheet with a value in a specific cell from another sheet. I have been able to get a result by using this formula. =$[2021 WP Year-End Forecast]1 * ({Project Costs - Cost - Labor OT…