-
Combining data from 2 sheets
Hi I have created 2 sheets: Employee Onboarding Employee KRAs Both the above sheets have one common field: Employee ID. Now I want to create a report by referencing to this common data field (e.g., Employee ID) and "blend" the data from both the sheets. Can we accomplish this please? Thanks Nasir
-
Countif logic not working
Hi Team, I need a formula that should count the based on Priority High, Medium, Low . So if the priority is High and Status is Completed it should count the number on closed column if the priority is High and status is In progress,Hold its should count the number on open column like wise we have to do for Low and medium.…
-
Need help with "WEEKNUMBER" and "TODAY" formulas
Hi Community, I am having a hard time getting my "WEEKNUMBER" and "TODAY" formulas to work and I am hoping someone can point out what my mistake is. I have created a metrics sheet to count the number of action items due over then next 6 weeks. I'd like the sheet to show rolling weeks ahead. For example: Current Week,…
-
form and automation issue
J’ai créé un formulaire mais j’ai plusieurs problèmes : - Lorsque le formulaire est envoyé à un contact, il reçoit un e-mail qui n’a pas le même que celui que j’ai créé dans l’automatisation - toutes les lignes sont jaunes dans l’e-mail - la personne qui fabrique/complète le formulaire que son nom n’apparaît pas dans…
-
How to count checkboxes-checked, between Nov 1st, 2020 and December 1st, 2020
I am looking for help creating a formula that works with the above question. I will replicate it for each month through one fiscal year timeline. Currently I have this formula which results in UNPARSEABLE. =COUNTIF({Data Range 3X}, true), COUNTIFS({Tuning Release Date Range}, >= A11, {Tuning Release Date Range}, <= A12) I…
-
If Statement
Hi Team, Can anyone help me how to write this condition In Smartsheet Thanks
-
Can we have chart in sheet like we do in excel
Hi There, Can we have chart in sheet like we do in excel I dont want dashboard I want the chart % to be in sheet column Thanks
-
Trying to Work with the VLOOKUP Function but hitting a wall
I'm attempting to access a separate sheet with some contact details for various clients. On my CLIENT SHEET I have 8 columns: Licensee, Billing Company, Contact, Contact Email, Street, City, State, Zip On my PROJECT SHEET I have various other project details, but one column is also named "licensee". In the Licensee column,…
-
Data Uploader feature
Hello Smartsheet community! I am a new member and I am trying to learn about Data Uploader. I would like to use Data Uploader in Smartsheet to load data into Multiple (Smartsheets)? Are there any tutorial videos that can help? What steps do I need to follow. Thank You for your help and guidance in advance.
-
When using Dynamic View logic, is it not possible to hide columns until approval?
I have quite a number of columns and I don't want all of them displayed in the panel until a trigger is reached for a grouping of each section. For example, until a recommendation is approved, I am hiding about 20 columns. Once approved, I want to make the next set of about 5 columns revealed for edit and once that…