-
Column Not Found
Hello! When I am filtering down information from a sheet into multiple reports, a few of my columns are labeled as 'not found'. I haven’t renamed the columns, which I understand could cause this -although on one of the columns I changed the column type from 'symbols' to 'text' fairly recently (but not for my other one).…
-
Vlookup
Hello, i have a sheet with billed claims including a column "Pending Amount", and "Detail ID", each line item has a different detail ID, now i want to update the pending amount column according to another sheet, i tried the simple Linking Cell method but it did not imported the pending amounts to the right detail ID's. and…
-
Important Reminder doesn't say Row # or Primary Column Name
I just filled out a large CRM on a new sheet with several hundred clients. I was using the reminder feature to remind myself to send certain people an email or more information. Out of the 18 reminders I created, 11 of them tell me the row # and primary column name, but 7 of them only say "Message: [my reminder message]".…
-
Smartsheet Barcodes
Hello All, I have a sheet that has a specific barcode for each card. Ideally we would use the barcode functionality to scan an item, then select the option to bring you to the correct card. With it set up, when I go to test it, it only works occasionally. It will usually only bring me to the column that the card is in and…
-
Translating Data from One Sheet to Another
I am looking for any method that could help me obtain the desired results. I have a tracking sheet titled “PM Sales Tracking” and within the tracking sheet there is a column that is called “Design Request” I have edited the column properties(design request) to a “dropdown list” with values of “yes and no” depending on the…
-
dependencies
I want a progress colun to have values such as: not started, started, pending and complete. When one of these values are selected in a drop down I would like a "% complete" column to populate automatically with a corresponding symbol with grey dot, quarter dot filled, half dot filled, 3/4th dot filled, black dot =…
-
To do list with extended tracking functionality
Hi there! We are collecting todos in a "topic list" connecting each task to one particular team member. Every task has a due date. Do you have a routine to track the development of these tasks? I.e. a task has been finished by me but now there are new challenges awaiting the next team member with the same task. I can just…
-
Financials: projected, actuals and variance
Hi! Very new to smartsheet and looking for any preset reports for tracking 3-4 year project financials, specifically projected spend, actuals, and variance. Does smartsheet have this type of reporting? Thanks!
-
Dashboard Notification?
Hello! Is it possible to create an email notification to a certain group of emails on a monthly basis with a dashboard link notifying them to review?
-
dynamic Completion updates
If I have a project plan with tasks assigned to team members and I want them to be able to update their completion percentages periodically. For example I want to to notify them a few hours before our status meeting. I don't want them to be able to edit the tasks or dates or anything else. I just want them to view and…
