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
Multiple Resources assigned to Contact List type column (new release today)
=SUMIFS(Amount:Amount, [Assigned To]:[Assigned To], [email protected])
does not match the [Assigned To] when the Contact name in [CheckName] matches. (It does for single instances)
It is possible to
I have several sheets that are identical. I actually created the additional sheets by using Save as New.
In all sheets when I enter an open date, follow up dates are supposed to auto-populate based on a formula (example =[Open date]12 + 2). In some sheets it is working fine, in others sheets, it is
In a Project Template Smartsheet, I would like to auto-assign a value to the " Assigned To" column when form data is uploaded. The "Assign To" column is a Contact List type.
I would like the "Assigned To" column to auto-select a value in the Contact List based on the form OR another column in my
I was able to preview the formula Help and Activity Log prior to the release. Really liking the Activity Log for a sheet we recently rolled out that has over 500 users updating it.
I'll have to spend more time on the formulas to give feedback.
I did notice that the Release Notes link
You may already have noticed that things look a little different here—we’ve upgraded the site to make it speedier and easier to use: