-
Does Not Equal
I have a formula that is working for me....the last part of the formula includes if the "Partner Driven" box is checked. I now want to run the formula if "Partner Driven" is unchecked - I think it includes <> but I can't figure out where to include the "does not equal. =COUNTIFS([Event Date]:[Event Date], <=Today(),…
-
RYGB - need to update Parent row with status of children
I am trying to get the Status in the Parent row to update automatically based off the Status of the child rows. I have the following formula in the Status column of the child rows: =IF([Phase Status]@row = "complete", "Blue", IF([Phase Status]@row = "At Risk", "Red", IF([Phase Status]@row = "On Hold", "Yellow", IF([End…
-
Cell linking
Hello all of my smartsheets are coming up with the message - more sheets referenced than allowed and I am not sure what to do about it as the sheets were created for me and i know they all link to a 'master' sheet and now that I've added more rows this message appears every time I open the sheet. Can someone help me out as…
-
Why smartsheet require login for published sheet?
Previous embed the smartsheet in the wiki by iFrame, which is published link , it doesn't require log in. But now it required log in, it is really annoy. Any way back to original way?
-
Copy of my responses
I'm not sure if this was already addressed in a previous post or not so I appreciate your patience. I created a registration form that has 6 choices for respondents to choose from. Is there a way to format the "copy of my response" email to only include the specific choice they picked? Currently, the email includes all 6…
-
series fill with numbers
This is probably an easy fix, but just like in excel, how do I drag and fill a number series? So if the first cell is #1, grab the bottom right corner and drag for 10 cells, I now want the cells to be 1,2,3,4,5,6,7,8,9,10.
-
Copy row data from one sheet to another
Is is possible to create a rule or manually copy data from one sheet to another? Not all the columns would match between the two sheets. We would need the ability to map which columns should be copied from one sheet to another.
-
At Risk
Hi , I been working on my smartsheet , and I didn't get the flag at the "At risk" Column. I did my formula to get my red flag , but I just get a 1 …
-
Sheet Summary cell reference changing?
Hello, I have built a sheet summary with formulas that look something like this, =COUNTIF(Provider1:Provider154, "Syringa"). The problem that keeps happening is that the cells I referenced to count, are changing randomly. For example, I will reopen the sheet and the formula looks like this, =COUNTIF(Provider24:Provider75,…
-
JIRA Connector/SmartSheet Forms for a Survey
If I want JIRA to automatically send a Smartsheets form used as a survey upon closing a ticket in a certain JIRA project, do I need the JIRA connector? Or will the JIRA connector not be able to do this for me? Any advice on how to do this is greatly appreciated!
