-
COUNTIFS Status and Year is Current(Cross-Sheet Formula)
Hello Community… Stuck trying to work out a COUNTIFS formula for Status is X and Year from a date column is current year, The first part I have… =COUNTIFS({Status}, "Pending Submission", The second part I am looking for help in this the {Submission Date} which is currently a date column is the current YEAR. I have this…
-
Users from China cannot logon
Since 3 Aug, users (Collaborators) from China cannot access Smartsheet anymore with the following message; "Due to network connectivity or feature updates, Smartsheet is experiencing slow loading times." Does anyone have the same experience and/or know how to solve this issue? Tks
-
Automated risk rating
Hi All, I am building a risks log and I am getting stuck building 'if and' statements to automate the rating. I have a drop-down column for Likelihood and a drop-down column for Impact, and based on these two fields, it would be great if the rating column showed Low, Medium, High, or Very High according to the matrix…
-
Generate PDF with data from multiple sheets?
I'm trying to create a project management system in Smartsheet, that has the ability to generate Invoice/Estimate PDFs. I already know how to generate PDFs with a single row, but is it possible to generate a PDF with data from multiple sheets? I would need to get data from the parent "Projects" sheet (for client name,…
-
Seeking Recommendations for Tracking Credentialing Process for Multiple Employees
I'm in search of an optimal template to effectively monitor the credentialing process for a group of at least 50 employees simultaneously. This process includes various stages, such as: Signing the contract date Starting the training date Completion date of training Training completion deadline Goal date for training…
-
Forms to Sheet
I have a sheet, loaded with our employees, into which I am trying to populate contact phone numbers using Forms. How can we get the user completing the Form and the contact info they share, to feed back to their corresponding name on the sheet list?
-
Lock rows from myself
Is there any way to lock a column or row so that I can’t edit it without unlocking or at least a warning? Similar to the “protect sheet” function in excel which must be turned off to edit locked cells. At a minimum, a warning that I am editing a locked cell would be great.
-
Does anyone have a solution they created for M&A?
I built something last year based off some Excel templates we had, but I don't love it. I'd love to connect with someone for some inspiration.
-
How do I set a sheet to be locked as a card or calendar view?
I use a sheet to identify actions that different departments need to complete. However, there are times that the client opens the sheet and it is on grid view. This confuses the clients and they need to return to card view. It would be better for the sheet to be locked in card view. Is this possible?
-
Looking to tie two columns together.. see below
Hello, I have one column that has a list of 'epics' (main categories) in the next column I have a list of all features. I need to somehow group a subset of the features to an 'epic' when the epic is chosen the user will only see the subset of features for that epic. How can I easily do this? Example provided in attached…
