Discussion List
VLOOKUP and COUNTIFS
Hi all, Hoping to get some help with a LOOKUP/COUNTIF formula. I'm trying to create a grid that counts issue location by month. I've created this column in the source sheet which is the range for the VLOOKUP. The sheet that this information needs to be pulled to: I'm struggling to create a formula that will count each…
Formula to Count Rows (only count parent rows and non-child rows)
I want to count the number of rows in my sheet. The sheet has some parent rows and some non-parent / non-child rows. I want to count all except child rows. Thanks!
Veränderte Darstellung eines Berichts nach Platzierung auf Dashboard (II)
Wieder wird ein Bericht durch Platzierung auf dem Dashboard verändert, so dass der Platzbedarf dieses Berichts sich sehr ungünstig verändert. Der Spaltentyp ist ein Dropdown und soll nicht verändert werden → Einträge dieses Spaltentyps werden auf dem Dashboard nicht nebeneinander sondern untereinander aufgeführt. Lässt…
Join/Collect , Index/Collect Multi-Select Column with Contact List return value
I am trying to update contacts on my main sheet based on values in a multi select column. Main Sheet Based on The selections in the Product Groups Affected I want to update the contacts in the Contact List Column based on my contacts in sheet 2 =JOIN(DISTINCT(COLLECT({QAlertAreas.Contacts Range 1}, {QAlertAreas.Contacts…
Unhide specific columns on a sheet
Instead of unhiding all columns to find one or two that are needed, it'd be great to be able to unhide specific ones, like Excel does with Tabs.
Remove sheet name from workload schedule
Hello, I think I know the answer but wanted to ask. Is there a way to remove the sheet name from the Workload Schedule in core Smartsheet (not in the Resource Management application)? From what I can see you can only view the workload schedule for the sheet you are in, so having the sheet name in the view is redundant. My…
I would like to get field value to use in Form setting - Redirect URL
Is there a way to get access to a form value and reference it in the Form settings section "Send user to a link"? This would allow me to make dynamic redirects on form submission. I don't think there is but didn't know if there was a way to use brackets or something to reference a field {Column Name} or something.
Control Center Blueprint Not Appearing
I have two blueprints in Control Center and when I go to create a project, neither appear as an option. I've tried creating a duplicate of an existing blueprint but still am not presented with any option to select a project when creating a new project from CC. I tried checking an existing blueprint settings and when I get…
Moved: Merged: Make the Undo Button Active
This discussion has been moved.
Datashuttle to Smartsheet date parsing
So I have come across another new fun issue that is quite a conundrum, I know that datashuttle wants the date in this precise format to work with data table ("yyyy-MM-ddTHH:mm:ssZ") but recently I have had a similar problem that I encountered when working with data table. The date gets swapped around when there is a…