-
Sprachvarianten in smartsheet
Ist es möglich Inhalte aus Blättern/Berichten/… über eine Funktionalität „Varianten“ in beliebigen Sprachen anzulegen um nach Bedarf standortunabhängig zwischen Sprachen zu wechseln?
-
COUNTIFS with multiple inputs and dates
I'm trying include a date range with counting the number of applicants within various depts, in certain date ranges, but it's saying incorrect argument set. =COUNTIFS(DISTINCT([Name of Requestor]:[Name of Requestor], [Submission Date]:[Submission Date], AND(@cell > DATE (2023, 9, 30), @cell <= DATE(2023, 12, 31))))…
-
Trouble Reaching Smartsheet - errorCode: 63
Hello all - We have a sheet that is refusing to save. Each time we try, we receive the following message. Anyone have any ideas on how to resolve this? Thank you!
-
Review a Formula
I am trying to sum all noted columns and getting UNPARSEABLE. Help! =SUM([A. Need for the Project/ Project Narrative]@row, [A. IPVE Need for the Project/ Project Narrative:]@row, [BONUS]@row, [B. Demonstration of Experience and Proposed Servic]@row, [B. IPVE Demonstration of Experience and Proposed]@row, [C. Demonstration…
-
Parent & Child Formulas in the Same Column?
My sheet is structured as a sort of tiered task checklist. There are several Parent rows with varying numbers of Child rows. There are two columns that are involved with my issue: the first is a "Status" column, and the second is a sort of "True/False" binary check labelled as "% Complete." There are no formulas in the…
-
Text size on dashboard
I created a dashboard with the intention saving it to a PDF. However, the font in the body of the reports that I included on the dashboard is very small (I think 10 pt). Is there a way to change the font for the body of the report on the dashboard? I am able to change the font when I go to the report, but that does not…
-
SUMIFS Formula and Blank Cells
We have a formula which will value sales forecasts for this month, next month and month 2. It works fine when the sell value and date columns are all populated. But we have some sell values where the project date is not known and is blank. The formula does not work until we add a date or clear the sell value ?…
-
Issue with text parsing on date/time populated by automation
I'm having an issue where I have a created date column, then a date column that referenced the created date column and uses text parsing to remove the time. formula below: =DATE(VALUE(20 + MID([Issue Opened Date]@row, 7, 2)), VALUE(LEFT([Issue Opened Date]@row, 2)), VALUE(MID([Issue Opened Date]@row, 4, 2))) This functions…
-
Auto-Populate Row
Hello, I am looking for a different method than using the update request form in each row. My sheet has 800 people. If there's a submission form with an attachment that auto-populates the specific given name of each row, that would be very genius work. I appreciate any help you can provide. ~Anj MaineHealth
-
Count Collect formula crashing large sheet - Scheduling conflict identification
Hello, I am running a Count(Collect) on a sheet with 8000 records. The formula calculates for a small number of records but if I make it a column formula or copy it to every cell then the sheet crashes. Does anyone know how to count thousands of rows that meet certain conditions without crashing the sheet? Purpose of…