-
IF statement to pull value from another sheet if a checkbox is ticked
Hi all, I'm trying to have a link between a risk register into an issues register and I don't know if it's simply my code or if this isn't possible in smart sheets. I have a column in my risk register with a checkbox that gets ticked when a risk has become an issue. I want my issue register to have a column listing the…
-
Report vertically versus horizontal
I'm setting up a new tracking sheet which will have multiple columns (about 50). For ease of displaying these to end users, I would like to 'report' them vertically. Is that possible in SmartSheets? FYI, the reason for now setting up vertically is to preserve field format (date versus text). For Example: Currently displays…
-
Creating Alert to Notify Users Once Agreement Signed
Hello, I am trying to create an alert that would notify users once an agreement has been signed. I have watched some Smartsheet videos but I'm still a bit confused on how to create one. Why might the “Automation” button not appear near to “File” button even though I am the Smartsheet owner? See the attachment.
-
Unable to access created discussions
After posting a question (creating a discussion) I am unable to navigate to see it. I only receive the message "You are not authorized to access this page." upon clicking the discussion link. Why is that??
-
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.
