-
Adding Days to a Date derived from a formula
Hi All, I am trying to add a Follow Up Date to my sheet, following a Submission Date. I tried: =[Submission Date]@row + 14 and instead of getting a date 14 days in the future, I am just getting the number 14 added at the end of the line. Both columns are set to Date Types. The Submission Date is derived from a formula -…
-
Is there a way that I can have a return date once something is "APPROVED"?
Hello! I'm trying to have a cell populate with the date that "APPROVED" is clicked. Ex: If "DC Ha Review" has "APPROVED" chosen in the dropdown, I wanted the Approval Date column to populate with that date. So, as I've chosen "APPROVED" in that column, the Approval Date column would have today's date. Any help would be…
-
Formatting not staying the same for new form fills
I noticed that in my sheets the $ currency column formatting or the align formatting do not stay the same as the rest of the column for new form fills. For example, before if I inputted in 100 in the $ section it would go to the sheet as $100 and on certain columns they would be automatically centered but now they just…
-
Grouping a Sheet that Automatically Collapses Records
I have a sheet with a lot of data and when I try to group by a column everything collapses. I had read that if there are 2,500 row entries that collapsing automatically happens, but wasn't exactly sure. Is there a workaround for this kind of issue?
-
Ability to set font size in report
I would like the ability to control the font size in a report independently from the base sheet. Currently, the report font size is controlled by the base sheet. I have a sheet with a font size of 10, and it is readable on my computer. I created a report with this sheet and put it on a dashboard, but the font size seems…
-
Sequence Duplicate Number
is there any formula to achive this kind of output? Im referring to count RFP ref duplicates
-
Quisiera saber como mejorar el procesamiento de más de 2500 filas
-
How to get permalink for sheet in report through API
I'm using the API to retrieve report data - I was hoping it would include a permalink for the originating sheet itself, as it's appears under the "Sheet Name" in the UI but the value returned for that row is just the Sheet name. I'd rather not have to make a second API call to then retrieve the permalink and wanted to…
-
How to Automatically Populate Summary Data for Multiple Jobs Across Sheets?
This discussion was created from comments split from: Assistance pulling information from one sheet to another automatically.
-
Why my Data Shuttle workflow been archived automatically?
I created a data shuttle workflow to upload a file from SharePoint, but it has been archived by smartsheet automatically. Could you please help to let me know what's the reason?
