-
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?
-
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.
-
How can I use Conditional Formatting for date in the past or future when a formula created the date
Hi Everyone, Thank you for your time in reading this. How can I use Conditional Formatting for date in the past or future when a formula created the date? The black columns are different dates generated. The 2 yellow columns are then selecting the relevant date based on different criteria. The white columns are me trying…
-
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…
-
INVALID OPERATION ERROR - HELP NEEDED
Thank you in advance for your help. I actually worked with Smaartsheet's AI Help to generate and work through the formula. I have checked it twice and still get the same error message. Here is the formula: =IF(AND([Tester ID]@row = {DE2ET Tester ID}, [Scenario ID]@row = {DE2ET Scenario ID},…
-
Help with INDEX/DISTINCT Not Working!!
I have the following formula: =IFERROR(IF(Auto@row = 0, "COMPANY NAME", INDEX(DISTINCT({Company Name}), [Row ID]@row )), "") Problem is - it has stopped working. It pulled out the first 115 vendors out of 425 items, and then stopped. Is there a maximum number of distinct items it will pull into a list? I do not see any…
-
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…