-
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…
-
Alert Email Triggers a Checkbox
Hello everyone! New to the community, but loving how detailed Smartsheet is! I am setting up alerts to trigger when a due date is approaching, 6 months, 3 months and 1 month to staff whose certifications will expire on that date. I would love for the alert to trigger an additional action, to check a box in the cell…
-
Capture date when row changes
Hi, I have a status column in my row that changes from "animating" to "approved" and would like the start and end date columns to update when status is changed. ie: 1. When status column changes to "animating" - start date needs to capture the date(fixed value) it was changed to "animating" 2. When status column changes to…
