-
RYG balls formula displaying text only
I've read through all the replies on this but have not found the resolution yet I want to display RYG balls in a new column i created that corresponds to the project Status and Finish Date. The new column Properties is RYG Balls The formula works, but only shows as text Formula i created: =IF(Status@row = "Complete",…
-
Dynamic View: Give access for requestors via their email address
Hi Community, we are using Status View at the moment to share the actual status of IT requests (Demands) to the requestors of different department. The access is given to the requestor via their email address they have to maintain while handing in the request and then they have to login in to status view with this email…
-
Identify duplicate dates and exclude blank cells
I am working with a SmartSheet that is used by multiple people to schedule meetings. I am trying to check for duplicate meeting dates within two columns "Proposed Date" and "Proposed End (if multiple days are needed)". Dates are entered in rows 7-28. I have added a checkbox column titled "Duplicate Date" to be checked if a…
-
Populating a Second Sheet
I have a form created for a sheet so that when it is submitted it adds a row to Sheet 1. How do I have a second sheet recognize that a new row has been added to Sheet 1 so that it can pull data from a few of the columns? Thank you, Matt
-
QBO and Smartsheet
Is there a way to link an invoice from QBO to a field in Smartsheet?
-
Status for At Risk tasks due in 7 days
I have 4 status categories for my project with respective RYGB balls: * Complete (blue) * At Risk (red) * Requires Attention (yellow) * On Track (green) My current formula in the Health column automatically changes the RYGB balls when the status is changed manually: =IF(Status2 = "On Track", "Green", IF(Status2 =…
-
Update requests to more than a person
Hi all, I have a spreadsheet that has set up an "Update request". Now, that same update request was set up to notify both myself and my colleague (since i was on annual leave recently, so nothing was getting left behind). What happens is, since there are 2 people in the automation, the update request only gets cleared…
-
Stuck trying to rollup with index, vlookup, and match
Hey folks, any idea how to pull this information onto another sheet horizontally? Basically, I am trying to consolidate some project information as seen in the "Source" screenshot. This particular sheet has the status for multiple items for the same project, but lists the same project on multiple rows. You can see this in…
-
SmartSheet Recent Update - Attachments/Versions
With the recent update to SmartSheets, our company has seen a few issues. The first issue has been the version numbers. If you look at the example below, the version numbers are out of order. We deal with a variety of freelancers that don't work for the company, but rely heavily on the version numbers. Now with them being…
-
SUMIFS Statements
Hi I have been having a lot of trouble getting SUMIFS statement to work always having the result unparseable - =SUMIFS(FTE2:FTE589,Fund Source2:Fund Source589,"MEMS",Unit2:Unit589,"Aquatic Environment") I have tried multiple times with just the column title and also selecting cells - I can get the statement to work…
