-
Counting people with the same email domain in a multiselect assigned to cell
Hi there I have a multiselect Assigned To column linked to a contact list. So the contacts are displayed with their full names. Email addresses are shown in the hover over menu for each contact as per usual. I want to count how many of the contacts in the cell belong to the same company. I.e. have the same email domain. In…
-
Workflow sending notification through Smartsheet but not email.
I thought based on my personal settings I can get an email notification from workflows but I do not receive one. It only comes through Smartsheet at the top right where the bell is listed. How can I get this through email?
-
Determining Final Approval Status
I have an approval flow that can go to one of three contacts (sometimes two). I want to add a Final Status column to make it easier to count in a summary sheet and eventual put it on a dashboard. I'm trying to create a formula with the following logic: If any of the three columns contains "Denied", the Final Status is…
-
How to create 2-way sharing across sheets?
Hi, I am trying to make certain cells accessible for 2 way sharing. Is there a function like cell-linking that is available 2-ways? There is some financial data but mostly personnel/task and resources. Thank you, Esperanza
-
Formula error on Duplicate date check
Have found this formula in previous discussions but is unparseable. I have gone through it a couple of times and think it is down to wrongly set parentheses, or? Slutdato=enddate, Startdato=start date. Looking to flag (double booking) if startdates or enddates overlap. =IF(ISBLANK(Startdato@row; “”);…
-
When I try to download Project Templates I get a message saying I already have them.
I choose 'save as new' and nothing happened. My sheets list does not show any templates. How do I download the templates?
-
formula for daily count
I'm looking to count how many times "blank" occurs in the status column per date. Entries are made daily and some days have multiple entries. I would like to set up a way to get a count of number of entries per day.
-
Automatic report creation with custom template
Hi! I am working on creating a report in which data is obtained using a Smartsheet form. For each new answer on the form, a new report or Dashboard must be created, which must have the format below. I wonder if there is any tool, API or integration with any other platform that would make this possible? Any help is much…
-
Gantt view with multiple assigners
I have a project with dependencies and multiple assigners enabled. I would except that the tasks duration will be reduced by the number of ppl working on the project, but that's not the case. It seems duration column and the gantt view ignores the assigners feature - the duration stays the same even when selecting multiple…
-
Change Color of 'Color by Column' on Calendar App
Hello! Is there a way to change the colors set by the 'Color by Column' design option on the Calendar App?