-
Add Contact details on bulk upload
I am trying to add contact details on the bulk upload but it allows me to add just name and email. I want to add Name, title, email, company name, office phone number, mobile phone number etc. how can i do that?
-
What reports are tied to a sheet?
Hi - is there a way to see which reports a particular sheet is feeding?
-
Moving singular cell data into a sheet from a master sheet with autonomy?
I am sure this has been asked before, but I have scoured many forums and attempted many solutions but to no avail. My issue: I have a sheet (let's call it master) that holds metadata. I also have another sheet (let's call it Department) that relies on a single piece of metadata from Master, but also requires the ability to…
-
Recording Week Tasks Were Completed
Hi all! I'm back with an old problem that rattled me a few months ago. Basically, when a task is completed, its date of completion is saved. For the sake of being able to a process this data in a more comprehensive manner, we want to take that date, and assign it a "weekOfCompletion". Another note, is that the weeks here…
-
How do i create a formula to source information from another sheet with multiple countifs?
I am trying to setup an automated metrics sheet from many other sheets and I am stuck on the very first "reference another sheet" formula due to the conditions (countifs) that I'm trying to get it to pick up. Here's the example: The metric sheet is trying to count KPI's from other sheets, for this particular instance a…
-
Requesting assistance with multipart COUNTIFS formula
Hi all, My team and I currently use Smartsheet to track monthly referral information. At the beginning of each month, we are looking to obtain the number of referrals received for the prior month (ex: because it is January, we want to capture data from December). Here is what we are trying to track: How many "SEN"…
-
Why does my Metrics constantly stop calculating correctly?
I've been making a "Metrics" sheet for some time now, and in the beginning everything was calculating fine. But it seems to be when I add more "data tables" if you will, or more metrics, some tables stop calculating correctly. Here is what my sheet looks like for a better understanding So, the first few-ish sections will…
-
Dual Horizontal Split Column Option
I know this probably isn't possible but I'll ask anyway. :) Is it possible to create a horizontal split on a sheet where the "top" split would have different sets of columns than the "bottom" split? It would be like having two primary rows on a single sheet. This would be like having two sheets in one for more complete…
-
Quick Link or Chart for Capacity Limits
I am frequently having to refresh my memory of capcity limits for cells in a sheet, workflows per sheet, etc. It would a great tool to have a quick link to a chart in Help or Community that is quicker to find or easily searchable within Help. Thanks!
-
Pro/Cons: Teams using Dynamic View vs the Sheet itself
I am looking for your thoughts about teams using Dynamic View vs going directly to the sheet itself to add new line items and editing. Reason for the asking is that I have some teams that are used to working with Excel to manage their list of activities and the quick copy/paste abilities you have there. In Dynamic View,…