-
How can i read activity log using c#.net through API...?
I need to restore a specific row which are deleted from the original sheet, and i am using API to achieve this with C#.NET. Our idea is to create new helper sheet using c#, which contains deleted rows in it, That has to get updated by reading data from activity log May i get any suggestions. Thank you in advance.
-
Inconsistent Alerts for comments made
Hi, We would like to have alerts being sent out when someone adds a comment. There is a workflow that I believe should cover this, but am finding that it doesn't always work/trigger. I have 8 people accessing the sheet and have an alert for each person, 6 with the same settings. To me the 6 people should always get an…
-
No idea where to start?!?!?
Hi all! New to smartsheet and struggling with formulas. Here is the sheet I am currently working with (Sheet A) I want the column labeled DC AVG to populate the total AVG for all Doc Control lines, from the Date of Inspection and any dates prior. (I manually populated the existing data in DC AVG) Similarly for LP AVG, I…
-
Prohibit a cell from being marked as complete
Hi everyone, Does anyone know how you can keep someone from completing a line item? I have a sheet where I ask for a resolution to an issue and some users are marking the item as complete without providing the details of the resolution. I would like to block them from the cell until data is entered into the resolution…
-
How can I best organize lots of different 'tags' to sort through
I'm moving a sheet over from Google Sheets. Right now we have a column for 'Specialties' for different medical providers and it contains keywords we need to be able to search by. I need to be able to sort through this data quickly. I don't necessarily want it as a drop down because there are over 100 different…
-
Formula when a column has a checkbox
I cannot seem to find this answer: When a column has a checkbox, another column must have data in it or it will turn red Example. If someone is needed on site (it is checked) then a person(s) name must be in the box. They cannot leave it blank or it will be red. On Site Person <star> Contact List or cell is RED
-
Merged: "Log in as" Feature for System Admins
This discussion has been merged.
-
Aligning week number to financial year
Hiya, Asking this question again as I have still seen no solution here. In a gantt chart is it possible to align the week number with a financial year? In our business our financial year starts the first week of July - This however comes up as week 27, not week 1. Cheers
-
How to set-up Data Shuttle to show changes from the last time a workflow was run.
Hi! I'm trying to figure out how to set-up Data Shuttle to show changes from the last time a workflow was run. For example, I have a sheet with the following columns. "Job Title", "Job Code", "Posting Number" (Posting Number is the unique identifier) and "All Submitted Applications". "All Submitted Applications" is the…
-
Missing Jira field in SmartSheet Workflow
Hi team, I am unable to add some fields though those fields are available within Create and Edit Issue screens. Those missing fields as in the red box of a screenshot. Can you help to look into this issue, please? Thank you!