-
01/01/70 View Activity Log Issue
Hi all, I see more and more issues in multiple of my sheets using date. The issue is for every data column including created date and just date. This results in data not coming through properly in aggregations, indexmatches with date in it, column formulas etc. Is anyone else experiencing the same issue and how could this…
-
How to calculate % Planned in Father Rows?
Hi Community I created a new column to calculate the planned percentage in my project; however, in the father rows is not calculating correctly, even if I tied the percentage between complete and Planned, the percentage is not the same. I am using the following formula =IFERROR(IF(Finalizar@row = Inicio@row , IF(TODAY() >=…
-
Missing Send Update Request Option on Sheet
I am no longer able to right click on a row or use the 3 dot menu to send an update request. When I created this sheet, the option was available but I cannot seem to find it now. To my knowledge, nothing has changed with the sheet permissions/settings. I am attaching an image of the menu I get without the Send Update…
-
Flag first occurrence as “Unique” and others as “Duplicate” by person + date
Hi Community, I’m working in a sheet with a bunch of historical data that has these key columns: [Personnel Name] (staff contacts) Date (date) [Duplicate Check] (text, where I want the formula to live) What I’d like to do is: Treat each combination of [Personnel Name] + Date as a group. For each person+date group, mark…
-
Managing dates
Hi SS Community! I have a feeling this maybe a simple answer, but I have looked on the internet with no resolve: I have "Project Plans" for each one of my projects. I use dependency settings. For dates I have Start Date, Due Date, ESTIMATED NUMBER OF DAYS TO COMPLETE, Estimated Completion Date and Complete Date (Record)…
-
Adding date ranges to column headers
Hello Smartsheet Community, I saw something at the conference in November and I'm having a hard time remembering what it was called so that I can figure out how to use it, I think it was a "series". Here's my problem: I have several sheets that I am using to create "block based" schedules, each block is defined by dates,…
-
Workflow Notifications for sub-subtasks
Hi, I set up a workflow notification to request updates on projects due today, or past due for an entire project sheet. But I would like to know how I can setup notifications only for the sub-subtasks row, if possible, without a helper column. Thanks!
-
Blurry image on Mobile app
Hi, I had attached an image on my sheet and tried to view it on the mobile app and the written details and the image itself are quite blurry and unreadable. Is anyone else encountering this. Please advise a work around as my customers prefer using the mobile and viewing images is important for our project. Its inconvenient…
-
Rolling budget/spend tracker
I have a bit of quandary with a recurring task, wherein I am tracking weekly budget allocations and tracking what is NOT spent. Currently, I have a basic sheet where my contractors/vendors upload a patient record, which is just a sign-in sheet, and I manually count the hours used. Each of these sheets represents a maximum…
-
Desktop app - copy and paste in Table view.... or lack of
When are we going to get copy and paste in table view - the lack of this basic function makes this view unusable.