-
Do you know why Smartsheet 'forgets' my existing subscription?
I subscribed and paid for a yearly Pro subscription this October. Everything worked as usual for 3 weeks, then Smartsheet seemed to forget my account and email address completely. When I tried to sign in after 2 weeks of not using it, it requested me to sign up for the trial again. Nothing else worked with the same email…
-
Subtract Invoice amount from Total based on Status, in Parent-Child relationship
Hi all, I am new to create sheets, but I am trying to create a solution to track forecasted invoices that need to be sent out. I want to put each invoice total separately and when the status is marked as "Complete" I would like to have it subtracted from the Contract Amount to show the Contract Balance. I set it up so the…
-
how to set up info sheet to feed into Resource Management
I have entered this data and am using it as a way to track allocations across different projects. The different projects are indicated by the different WRT #s in column 1. I need to then summarize the last 2 columns by WRT #, which I've done here in a report. I am wanting to add some type of flag or conditional formatting…
-
How to calculate time in smartsheet
Hi, How to calculate difference in time in smartsheet for example Start Time = 12:23:20 and End Time = 20:23:20 I want the difference between this two time in third column = 8:00:00
-
Need a column formula to pull balance from last row
I have looked at multiple questions and threads on the community and not found an answer that works. I am trying to create a column formula that pulls the [Balance] from the previous row into the current row entry. I was getting a #circular reference error, I tried IFERROR and some recommendations on other posts, but…
-
Text Wrapping is not working.
Hi, I've created a new sheet and a form, I've applied text wrap to the columns that might need it and I've tested certain cells, inputting more text than the cell than would be visible. I've clicked an unclicked the text wrap button on the menu... nothing is happening. I've saved and refreshed the sheet...still no text…
-
SUMIFS formula syntax
Hi, I believe I'm needing help with the syntax for the SUMIFS formula. See the below photo with example data: I am wanting to total the revenue generated for each department (category) and sub department (topic) only if the status is labeled "Won" - which the above screenshot would not be included in the total. The "Topic"…
-
Merged: ADD MORE CURRENCIES
This discussion has been merged.
-
How to create a basic pricing estimate/quote with dashboard
Hi Everyone How can I create a basic pricing estimate with a dashboard for 4 major service offerings that I am sending to the government for assessment? It only needs to be simple, nothing spectacular. I need something that looks good at the very least with a few metrics involved because its still early days for anything…
-
IF Function / Formula Help
I have created a budget sheet template and need to add seasonlisation to identify cross-charges by month. Rather than doing this manually every time, I would like to add a formula that pulls the data from another cell, but based on information in a 3rd cell. I was hoping it would be as simplistic as: =IF([Activity Month]3)…
