-
Count free
Hello, delete a free account, I have a licensed one and I want to add the free one there once it has been deleted but it tells me that my account already appears in another smartsheet account when I just deleted it, can anyone support me?
-
creating row report & summary report from 1 sheet
I love the new summary report option but I still want to be able to create a row report from the same sheet. I have already created a summary report but I also need to add a row report to my dashboard for the same sheet. I used the summary report to create a chart on my dashboard. I tried to create a row report but the…
-
If(and with RYG buttons
I am trying to set color buttons to the status of each row. Currently I am getting #UNPARSEABLE My formula is: =IF([Status]@row = "Complete", "Yellow", " ")IF(AND([Status]@row = "Pending", "Yellow", " ")IF(AND([Status]@row = "InProcess", "Yellow", " ")IF(AND([Status]@row = "In Progress", "Yellow", " ")IF((AND([Status]@row…
-
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…
