-
Pulling Parent Data without Grandparent in a column with a column formula
I would like to pull data from a parent row into the children but with a column formula it goes back to the grandparent, how do I exclude the grandparent data?
-
In Calendar and Card Edit View, Hide Data in Hidden Columns
Currently in Calendar and Card view, all data from all columns is visible when you double click on a line item. It would be great if data in hidden columns was not shown in the Card or Calendar edit view, or if there was a way to select what was visible in the edit view.
-
Is there a way to set up fiscal months other than a giant IF statement
We have our fiscal months that always end on a Saturday. So some months are Fiscal Month April 2024 will be from 4/1 - 5/3 = April, May is 5/4-5/31, etc. I made a Fiscal Months sheet with start date and end date for 3 years. I now want to cross reference that so when I import by revenue, bookings, etc. it will take the…
-
Help converting an Excel formula to work in SS
I've inherited an Excel spreadsheet that is currently uploaded via DataShuttle into SS. However, I have to add six columns and formulas in Excel prior to completing the upload via DataShuttle (data is exported to Excel; six columns are added w/formulas; then DataShuttle moves it to SS). I can't figure out how to convert…
-
Report as a web content widget?
I'm looking to make a report available as a web content widget. However, the only option when publishing the report is "Read Only". I need this report to be interactive right on the dashboard. Is there any other way to accomplish this? A report widget does not allow me to edit the report content on the dashboard.
-
Countifs formula to count tasks in a range last 7 days to future 7 days
This seemingly simple formula is giving me problems. I want it to count the number of tasks due in the past 7 days through the next 7 days. I am working with the following and getting "#UNPARSEABLE": =COUNTIFS({Owner}, "Joe", {Status}, "In Progress"), {Due}, >= TODAY(-7), {Due}, <= TODAY(+7) I'd appreciate any assistance…
-
How can I create a formula to list names that haven't been added (cross sheet)
I am trying to have a summary list all of the names that are on one source sheet but are not populated in destination sheet. I am creating a time entry process for my company and would like a summary section to show who has not yet submitted time based on the list from another sheet. So if Sanchez has not entered their…
-
All fields on the Smartsheet form is showing despite logic being applied to all.
Hello Everyone, So I built a form a couple of months back which was working fine with logic applied to it, but suddenly today when I opened the form, I saw all the fields are shown right from the start which should not be the case. Originally the form should only show the Full Name Email Department Request: On the basis of…
-
COUNTIFS not picking up some values - Name / Email
I am trying to count the number of Submissions by Submitter. The Submitter uses a Form to enter a line on the Sheet. They identify themselves by email address on the Form. The COUNTIFS formula I'm using at first seemed to get hung up on whether the form displayed a name (for the contact) or the email address. I've updated…
-
Access Requests
Morning All, we have a lot of staff requesting access to various sheets, I am looking for ideas on how to maintain this - keep track of it - when someone requests access having the sheet owner or manager of that department approve the access and the level of access Any ideas :-)