-
IF WITH 2 CRITERIA
I'm looking to make a formula that will do the following: search all instances in Column2 for "A" IF subsequent Column3 has a value of "YES"....if all "A"s = "YES" than return a value of "YES" otherwise "NO" I included an image that hopefully clarifies this a little more. in the image I show 3 "A"s in Column2, 2=YES and…
-
Jira Smartsheet Workflows are not static
Not sure if I am expressing this correctly. However, my workflow I set up on Friday worked perfectly, but I noticed it was not updating when changes were made in Jira. When I go to edit to looked back at the workflow the Settings say under Jira project: Configure Jira Instance . However, it does show the proper Jira…
-
Facilities Maintenance Plan
Hi, Does anyone use SS for their facilities maintenance planning and tracking? If so, I would be interested in touching base. We are putting together a multi-year facilities maintenance program in SS and any help would be appreciated. Thank you, Archie Lopez
-
Moving Rows with a Formula
Hello, I have several Tasks. I want a formula that moves the whole row of a task, upon it's completion, to the bottom of the task list. Thank you for your help, Sohlbe
-
Formulas to durations or equivalent
I am building a production scheduler with a built in calculator where by the operator can adjust the labour allocation to test the duration output. My problem is Smartsheet won't allow durations to be edited by way of a formula. Also I am wanting the variables to be as follows: Completion Date - Constant (fixed) Variable…
-
Sum of a column by cell color?
Not sure if this is possible or not. I was looking into conditional formatting, but didn't seem to find anything that would work. I simply want to get the sum of a column based on the color of the cell in the column. In other words, I only want to see the sum of red cells and exclude green cells. If this is not possible,…
-
Changed Duration Time for Report
Hi, I just updated a couple of my sheets and changed the duration time to "0" to reflect a milestone. When I run my milestone report these changes are not updated. Is there a delay for some reason. I thought that updates once saved would be immediately reflected. -Laura
-
Cell Linking Blank Templates
I'm looking to create a "Packet" of 3 sheets that cell link together to be used for multiple projects. Is it possible to create 2-3 Blank Templates set up to cell link with one another, without it getting altered when the blank template is used again for a different project? Hopefully this explaination makes sense. Thanks…
-
Beta of New UI?
Is there any way to get a beta view of the new UI? Just encountering UI issues while working in currnet view. Small things like makin the tabs smaller or multi row. Using more of the screen etc. I saw the new release will have many of my concerns addressed. But really wondering how to get on the inside track of beta views…
-
Date fields not working on Live Data Link API
This is day two of the date fields coming into our excel sheet as 01/01/1900 and it causing problems with our scheduling needs. What is the ETA of this getting resolved?
