-
Salesforce Integration- Worth it?
Hi everyone! We currently use Salesforce, Quip & Smartsheet however, we have not yet added the integration to sync them. Can anyone tell me what the huge advantage is to justify the price of the integration? The video links are a bit vague & I need to provide a few good reasons, other than an auto alert if a new…
-
Workflow creating multiple emails
Workflow is sending 4 duplicate emails. It's setup to run "When Triggered" with conditions set as: - when row is added (which only happens once) - specific value Any suggestions on how to stop this?
-
Please bring back the tabs...
The new December 2018 look prevents easy navigation and inhibits work-flow. This is not a positive update. I see numerous posts expressing the same opinion. Please bring the tabs back or make them an option.
-
Average for both columns
I have a dropdown columns with several choices and each choice represents % complete. The idea is to get the Circuit % complete for 1st and 2nd circuits columns but also It has ‘N/A” that will not count. It only count the column that doesn’t have it. This is what I tried: =AVG(IF([1st Circuit Status]@row = "Assigned to…
-
Average formula with error should give a blank cell
I used this formula below to give me the "DOC % Complete" but it is missing something. If the cell has “Cancelled” the Docs % Complete column should be blank but right now is giving me 50% =IFERROR(AVG(ISDATE([Design Circuit Recommendation Actual]@row), 0.5) + IF(ISDATE([Design Velo Recommendation Actual]@row), 0.5), "")…
-
Ops documentation storage
Hello Smartsheet community, I would like to know if anyone on the community is using Smartsheet to keep and maintain supplier scorecards on the healthcare industry or any other regulated industry?
-
Last day at ENGAGE!
As a new user of Smartsheet I came without big expectations. Three years ago I new about Smartsheet I was like "Why I would invest time on another Grid based platform...". I am an Excel, CRM, ERP guys.. So I passed at that point in time. However.... This has been one of the most productive conferences I have ever attended.…
-
First time at ENGAGE 2022 and loving it!
This is my second here at #Engage2022 in Seattle, WA. and I feel amazing! What an wonderful experience to be attending to. I really happy to be surrounded by a diverse and enthusiastic group of peers, this is a great example of how in-person events were something that we were all missing. Sharing insights, knowledge,…
-
TOTAL% COLUMN
-
Issue with CountIFs function
Hi all i'm currently attempting to use a COUNTIF function to count with 3 conditions. However my output comes up with 0 when there are more than 0 items that meet the criteria. Can anyone assist to see if my formula is incorrect? =COUNTIFS({Type}, HAS({Type}, "Storyline"), {Current Maintenance Assignee}, "Earl Prentice",…