-
Allow linked cells to trigger workflows
Just as the title says. It's really frustrating when you want linked cells to trigger a workflow but you can't.
-
Create Automation Rules with API
It would be convenient if we were able to actually create automation rules via the api rather than just modify. It would also be nice if the API automation functionality was improved, it's pretty limited.
-
Join Collect Formula not pulling contact info
I have a formula pulling contacts from one sheet to another that is working HOWEVER, it's not pulling them over as a contact with their emails attached and I have automations set up for email reminders and they won't be delivered because its not an email and just a name. Both columns are contact columns btw and everyone's…
-
Welcome to the online Smartsheet Community!
This is YOUR space to connect with people around the world who are driving achievement at work with Smartsheet. We’re so excited you’re here! (Learn about the supportive and helpful culture of our community by reviewing Community Guidelines or take a look at our full site terms attached below.) On the community platform,…
-
Can you create a multiple approver workflow with hiearchy of who it goes to after each approval?.
We have form where you can select who needs to approve a submission. All submissions go to one particular person, but after that approval it needs to go to the next position selected by the submitter, and then after that approval it goes to the next, etc. Is there away to do that?
-
Index Collect with a Date Range Criterion
I am trying to utilize an index collect formula that will cross-reference another sheet. Some of the reference criteria are numbers but two criteria need to narrow the options to a specific date range (i.e. >= DATE1 and < =DATE2). These columns are in date format. The data I am trying to bring back into the cell is a name…
-
Company Adoption
Hello Everyone, I’d love to hear how you’ve introduced Smartsheet at your company. What successes have you achieved? Were there any pain points or barriers you encountered along the way? If you have any best practices or recommendations for other users, please feel free to share. Your insights could be incredibly valuable!…
-
Combining IF(AND and IF(OR statements
Hi all, I am trying to build a combined IF statement for a date validation field. Both of these statements work on their own. The first statement returns "University Holiday" if the "Preferred Date" is a holiday... =IF(OR([Preferred Date*]1 = "09/02/19", [Preferred Date*]1 = "11/28/19", [Preferred Date*]1 = "11/29/19",…
-
SDLC Portal
Hello team - Has anyone built a SDLC workspace for complete tracking of a project or activity? I am trying to build the following and looking to see if any of you have found a good solution?
-
Dynamically referencing parent task row in COUNTIF/COUNT formula for child task completion ratio?
Hello Smartsheet Community, I'm trying to calculate the ratio of completed child tasks for a specific parent task in my sheet. Currently, I have a formula that works when I manually specify the parent task's row number: =COUNTIF(CHILDREN([Task Complete?]70), 1) / COUNT(CHILDREN([Task Complete?]70)) However, I want to make…
