-
Copy/ Duplicate a form
I am trying to duplicate an existing form so that I can make a change while keeping the existing form as is. I am in manage forms and the 3 icons usually there to enable duplicate (and other things as well) Is missing. Can you help me with this?
-
Is there a way to bulk remove access to Dynamic View but to not take away viewing access
We have been working with Smartsheet on the new costing structure. We would like to know is there a way to bulk remove access to Dynamic Views but in a way that it does not take away access for people to view them. Is this statement correct that in order to be able to add information in a Dynamic View they would need a…
-
Is anyone using Smartsheet as their CRM?
We are looking to convert to Smartsheet as a CRM, but wondered if anyone has done this and the steps they took to develop their system. Also, transferring the information from the current CRM onto Smartsheet, any tips for how you did this, manually or via CSV file? Need some help.
-
Help with using the PMO template to Manage an IT projects
Hello, I have a digital transformation plan that is set to span 3 years. I want to use the PMO template to setup an environment to manage plan. An IT PMO workspace of sort. I have a number of questions on best practices, managing projects sheets among other questions on how to setup the 7 domain projects that has other…
-
Converting Excel Formula
Hello, I am trying to build a formula that assesses several columns and returns results as a list. Kind Helpful Polite Cheerful Attentive Good Ok NeedsWork 5 4 3 2 1 Kind Helpful Polite Cheerful Attentive =TEXTJOIN(@, ",TRUE,IF(A@>4,"Kind",""),IF(B2>4,"Helpful"…..etc. works in Excel but I haven't been able to convert it to…
-
Options to display all formulas/functions in a sheet
Hi Community, I am a new user and would like to know if there is a way to view the formulas/functions within a sheet either as an ad hoc toggle on/off feature/shortcut or by leveraging the report builder. I understand that we could copy the formula/function body as text to a hidden column for reference or reporting.…
-
Cloning a column within a sheet
Has the cloning of a column within the same sheet feature been developed? I saw the discussion back in 2016. Thanks Christi
-
Is there a way to show a report of duplicate names across multiple sheets?
Hi all, I have about 6 sheets that act as master rosters for 6 different programs. I would like to have a report that shows which individuals show up across those multiple programs. Is there a way to filter a report to only show those individuals or is there another way of doing it that might be better?
-
COUNTIFS & ISDATE FORMULA
Good Afternoon, Hope you are safe in this winter weather. MY FORMULA is unparseable: =COUNTIFS([DEACTIVATE TIMESTAMP YR 5]:[DEACTIVATE TIMESTAMP YR 5], ISDATE(@cell ), [Abbreviated Org Name.]:[Abbreviated Org Name.], "CHARM")) The formula should count ONLY if any date is appears in column DEACTIVATE TIMESTAMP YR 5 = ANY…
-
COUNTIF & ISDATE FUNCTION
Good Afternoon All, I hope you are stating safe in this winter weather. I have a formula but to no avail I am getting unparseable. I want my COUNTIFS function to count only if there is a date in column (DEACTIVATE TIMESTAMP YR 5) = ANY DATE and count only if the specific criteria from on column (DEACTIVATE TIMESTAMP YR 5)…