-
Add Package Count Based on Customer
I have a sheet with a list of customers in one column, and then the following columns are City, Monday, Tuesday, Wednesday, Thursday, Friday. I need help with a formula that I can put in my sheet summary so that if the customer column says Staples (It can say this in multiple rows) that it will tell me the total package…
-
formula for raid log
I would like a formula that if a user selects risk in the type column and enters the risk information.. and later on in the project this risk becomes an issue.. the formula will auto score the likelihood column to default to 5. Can anyone help with this please?
-
Fix Errors Due To Managed References Within Collections
Sheets/reports within a Collection that have managed references to sources outside of the Collection will fail with errors for those formula cells. What's the point of Collections if you can't pull source data into it from outside the Collection in Workspaces you don't want people to have access to? I didn't have this…
-
Changes over Time - COUNTIFS?
I have a project where a group of users can submit a smartsheet form at any time to request a new enhancement to one or more of 3 tools. One of these tools is managed by an outside vendor and therefore management wants to be able to track number of enhancements submitted to them as well as how they progress through status…
-
Control Centre push an update to all provisioned worksheets
I have a large number of assets that have been provisioned through Control Center. I want to install a formula in one cell in a specific column. I thought I could update the template in the source folder of the blueprint and publish it, however, that functionality has been removed or I can't quite figure out how to do it.…
-
Merged: Update functions list to include regular expressions
This discussion has been merged.
-
Auto Check a box after 24 hours
I have tried to get smartsheet to auto check a box 24 hours after a row is created and column "Task Started" is not checked. =IF(AND([Task Started]@row <> 1, TODAY() - Created@row >= 1), 1) This returns #UNPARSEABLE. Any help would be appreciated.
-
Copy Parent Issue Key (link) into Child Row as a link
Hello! I am trying to pull the issue key link from my parent row into the child row. I have used the formula =PARENT([Issue Key]@row ) But it returns the text only, not a clickable link. Any ideas?
-
How to include start/end times (hh:mm) in addition to dates?
I’m building a detailed cutover/go-live schedule and need both date and time (hours:minutes) for each task’s start and end. The standard Date column type only records dates, which isn’t sufficient. I’ve read in a few places that Smartsheet has rolled out a Date/Time column type, but it doesn’t seem to be available in my…
-
Multiple Forms - Add info to existing row
Hello! We work with a registration form that feeds a master sheet, we want to add another form that will update or add a request for change for a registered contact, but we do not want to generate a new row, we want Smartsheet to match the name or ID to the initial registration and update the columns. Do we need a formula…