-
Sum formula using another sheet
I am trying to do a count of cases an investigator has completed between a date range (using a differen sheet) If I do a I have this formula in my Sheet summary and of course it works =COUNTIFS(Investigator:Investigator, "Vanessa", [Disposition date]:[Disposition date], @cell >= DATE(2020, 8, 1), [Disposition…
-
How to efficiently link data from one sheet to two other sheets
Hello, I'm trying to link data from a master sheet to two other sheets. Here is what I tried so far, but it's not working. Created a form on the Master Sheet. Tried Cell linking the master sheet to two other sheets. However the problem that I have is that because I am already using cell linking on this Master sheet to feed…
-
Prompt for Contact, then use Contact in Report Filter
Is it possible to setup a report that, when ran, it prompts the user for a Contact, and then uses that Contact in the report filter? Is it possible to use a 'prompt then filter' in a Grid without hard coding the contact info in the filter?
-
Smartsheet, built for failure
I'm have not found a proper place to lodge a complaint so as a last resort, I'm posting things here. [Dates and personal account information have been removed by moderators.] We are a smartsheet enterprise user located in Canberra Australia. A smartsheet client development manager based in Sydney reached out to me…
-
Updating Existing Row from Form Data
Hi - I have a request to create a sheet where a team member wants to input data, and then send a form link out for additional information to be collected. We would all of this information to be populated on one line Does anyone know if this is possible, and if so, how to do it? Thank you! Sheryl Sheldon Cincinnati…
-
Auto populating status
Hi I've created a new smartsheet to track submissions we're making to an outside authority and what stage the are at. I have a new line for each submission then a column for date the submission prep started, when it was submitted, when it was validated and finally approved. I'd like to have a column right at the beginning…
-
Not received notification mail
Hi Team, I have created workflow for auto notification based on some date criteria , notification trigger in criteria based date but not received any mail in my outlook inbox. I have received smartsheet notification at my smartsheet account not outlook inbox. an you please help me on the issue...
-
#CanDoCommunity Live Q&A: Event Management
#CanDoCommunity Live Q&A: Event Management Thursday, August 20 from 10-11a.m. PDT Join us Thursday, August 20 from 10-11 a.m. PDT for our #CanDoCommunity Live Q&A! Event experts from the Make-A-Wish Foundation, Intuit, and Smartsheet will be answering your questions about the evolving roles of #EventProfs in times of…
-
Formatting Options Inside Messages
I am setting up some automations and would like to add some formatting to the message being sent to a customer. For starters it seems like Smartsheets is ignoring carriage returns. And is there any way to insert a hyperlink? Thanks
-
Restricted one-time use of web form?
I saw some older posts regarding voting and wondered if any recent enhancements have been made? I have created a form, to facilitate anonymous voting -- a simple yes or no with a comment. I really like the idea of keeping my voting in Smartsheet with all the rest of my project planning; nice and centralized. The only…